sql - Unexpected output when using a CASE statement -



sql - Unexpected output when using a CASE statement -

i trying out random things using case statement when stumbled upon scenario. first statement throws error sec 1 works fine. can help me understand execution of case statement here.

select case when 1 = 1 'case 1' when 2 = 2 2 else 10 end select case when 1 = 1 1 when 2 = 2 'case 2' else 10 end

a case statement cannot homecoming more 1 single type. when there mix of types such int , varchar, type int has higher precedence , hence chosen type homecoming type of case statements. see http://msdn.microsoft.com/en-us/library/ms190309.aspx list of info type precedence.

your sec case statement fail if seek homecoming sec value ('case 2'); illustration with:

select case when 1=0 1 when 2=2 'case 2' else 10 end

sql sql-server tsql

Comments

Post a Comment

Popular posts from this blog

php - How to pass multiple values from url -

php - How to pass multiple values from url - i'm trying pass textbox , 1 select result value 1 page page.using url.but it's display error message. "parse error: syntax error, unexpected '' (t_encapsed_and_whitespace), expecting identifier (t_string) or variable (t_variable) or number (t_num_string) in c:.." while($value= mysqli_fetch_assoc($result)){ $apid=$value['apid']; echo("<tr> <td>". $value['apid'] ."</td> <td>".$value['email']."</td> <td>".$value['comments']."</td> <td>".'<input type="text" name="payment"/>'."</td> <td>"."<input type='text' name='apid' value='".$apid."' style='visibility:hidden' size='2'>"."</a>"."<a hre...
Read more

database - php search bar when I press submit with nothing in the search bar it shows all the data -

database - php search bar when I press submit with nothing in the search bar it shows all the data - the search fusion works correctly if press submit nil in search bar shows data. how message show saying nil has been entered search bar ?.i new php. <?php $mysql_host="host"; $mysql_database="database"; $mysql_user="username"; $mysql_password="password"; $dbconnect=@mysql_connect($mysql_host, $mysql_user, $mysql_password); // trys connect database if (!$dbconnect) { exit("an error has occurred - not connect database."); // if couldn't connect, allow user know } if(!mysql_select_db($mysql_database)) { exit("an error has occurred - not select database."); //if couldn't select db, allow user know } $output = ''; //collect if(isset($_post['search'])...
Read more

ios - How to load .png images from Documents folder of an app -

ios - How to load .png images from Documents folder of an app - i have .png images in documents folder of app when seek load them don't work :/ i have class methods saving , loading : uiimage+loadscan.h : #import <uikit/uikit.h> @interface uiimage (loadscan) - (void)savescan:(nsstring*)name; - (uiimage *)loadscan:(nsstring*)name; @end .m : #import "uiimage+loadscan.h" @implementation uiimage (loadscan) #pragma save , load - (void)savescan:(nsstring*)name{ if (self != nil) { nsarray *paths = nssearchpathfordirectoriesindomains(nsdocumentdirectory, nsuserdomainmask, yes); nsstring *documentsdirectory = [paths objectatindex:0]; nsstring* path = [documentsdirectory stringbyappendingpathcomponent: [nsstring stringwithstring:name] ]; nsdata* info = uiimagepngrepresentation(self); [data writetofile:path atomicall...
Read more