Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234»»

CASE vagaries Expand / Collapse
Author
Message
Posted Monday, September 9, 2013 7:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 6:22 AM
Points: 271, Visits: 96
Actually the answer is: @X is now A<
Post #1492793
Posted Monday, September 9, 2013 7:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 9, 2013 2:31 PM
Points: 5, Visits: 4
I agree. None of the the answers, A, B, C, or D, are correct. Because the ISNULL uses the data type of @x (Char(1)). The correct answer is '@X is A<'
Post #1492794
Posted Monday, September 9, 2013 8:25 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 7:55 AM
Points: 825, Visits: 254
I keeped looking at this one tying to get one of the answers. Got lucky and just picked the closest one.
Post #1492807
Posted Monday, September 9, 2013 9:09 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:38 PM
Points: 31,368, Visits: 15,834
A poor question, and incorrect answers. My apologies. I know I ran the code, but I'm guessing I didn't examine the answers closely enough.

I have updated the answers and awarded back points.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1492822
Posted Monday, September 9, 2013 9:50 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 8:43 AM
Points: 280, Visits: 552
Steve Jones - SSC Editor (9/9/2013)
I have updated the answers and awarded back points.


I was just about to say, don't know what everyone is talking about, the correct answer is there, I even double checked it in SSMS! Thanks Steve.
Post #1492845
Posted Monday, September 9, 2013 10:05 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:50 PM
Points: 2,500, Visits: 1,586
Ross.M (9/9/2013)
Steve Jones - SSC Editor (9/9/2013)
I have updated the answers and awarded back points.


I was just about to say, don't know what everyone is talking about, the correct answer is there, I even double checked it in SSMS! Thanks Steve.


+1 Some times it pays to come late to the game.





Not all gray hairs are Dinosaurs!
Post #1492851
Posted Monday, September 9, 2013 10:45 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:56 AM
Points: 3,417, Visits: 2,035
Miles Neale (9/9/2013)
Ross.M (9/9/2013)
Steve Jones - SSC Editor (9/9/2013)
I have updated the answers and awarded back points.


I was just about to say, don't know what everyone is talking about, the correct answer is there, I even double checked it in SSMS! Thanks Steve.


+1 Some times it pays to come late to the game.





+1
Post #1492867
Posted Monday, September 9, 2013 8:43 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:50 PM
Points: 7,923, Visits: 9,649
Steve Jones - SSC Editor (9/9/2013)
A poor question, and incorrect answers. My apologies. I know I ran the code, but I'm guessing I didn't examine the answers closely enough.

I have updated the answers and awarded back points.

Glad to see it's right now.


Tom
Post #1492972
Posted Tuesday, September 10, 2013 9:15 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
I am glad I got to answer this one after it was corrected.
Post #1493250
Posted Tuesday, September 10, 2013 11:20 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, September 14, 2014 12:30 AM
Points: 253, Visits: 540
learn a new thing today don't know that is null work in that way



Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script
Post #1493445
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse