Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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, May 11, 2016 1:17 AM
Points: 282, Visits: 100
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: Friday, July 24, 2015 10:50 AM
Points: 920, Visits: 287
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: 2 days ago @ 1:17 PM
Points: 34,146, Visits: 18,305
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: 2 days ago @ 5:24 AM
Points: 291, Visits: 699
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: Tuesday, January 26, 2016 9:10 AM
Points: 2,602, Visits: 1,694
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, September 7, 2016 9:05 AM
Points: 4,074, Visits: 2,292
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 3:43 AM
Points: 9,692, Visits: 11,733
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 9:55 AM
Points: 5,327, Visits: 4,495
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: Saturday, September 17, 2016 8:27 PM
Points: 258, Visits: 556
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