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 ««123»»

Reserved Words - 1 Expand / Collapse
Author
Message
Posted Wednesday, September 18, 2013 3:11 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 10:45 AM
Points: 673, Visits: 1,551
Stewart "Arturius" Campbell (9/18/2013)
Good question, Ron, thanks
Didn't even have to bother executing the T-SQL, which is, after all, what this is all about...


+1


ww; Raghu
--
There are only 10 types of people in the world, those who understand binary, and those who don't.

Note: (as of now) only.. 1 and 4 applies (i am on my way...)
Post #1495819
Posted Wednesday, September 18, 2013 8:01 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, March 24, 2014 3:38 AM
Points: 387, Visits: 228
Easy and educational. Thanks.
Post #1495933
Posted Wednesday, September 18, 2013 8:24 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:42 AM
Points: 2,763, Visits: 5,906
I need some coffee I calculated the type instead of the hours and got it wrong.


Luis C.
I am a great believer in luck, and I find the harder I work the more I have of it. Stephen Leacock

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1495940
Posted Wednesday, September 18, 2013 8:45 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 10:06 PM
Points: 8,283, Visits: 8,733
Toreador (9/18/2013)
Nice question, but I can't understand why the stuff about quoted identifiers is in the explanation. Surely the result is identical even if QUOTED_IDENTIFIER is On?

I think that wa the point of the question: the seting of quoted_identifier only affects the treatment quote marks as delimiters. not the treatment of square brackets.


Tom
Post #1495948
Posted Wednesday, September 18, 2013 9:04 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:26 AM
Points: 1,658, Visits: 6,002
L' Eomot Inversé (9/18/2013)
I think that wa the point of the question: the seting of quoted_identifier only affects the treatment quote marks as delimiters. not the treatment of square brackets.


You're probably right
Post #1495963
Posted Wednesday, September 18, 2013 9:33 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: Tuesday, April 15, 2014 12:05 PM
Points: 3,569, Visits: 72,411
Stewart "Arturius" Campbell (9/18/2013)
Good question, Ron, thanks
Didn't even have to bother executing the T-SQL, which is, after all, what this is all about...


Yes... yes it is... I too can claim this one :)




--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #1495984
Posted Wednesday, September 18, 2013 9:48 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: Today @ 6:36 AM
Points: 3,303, Visits: 2,349
Good question, Ron. It really made me look at the square brackets and field names and think it through before answering.


Tally Tables - Performance Personified
Best practices on how to ask questions
Post #1495994
Posted Wednesday, September 18, 2013 10:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 31, 2013 11:22 AM
Points: 160, Visits: 231
Well, and I failed to see something troublesome and answered correctly accidentily...

For me this question was therefore... ...welllll...


________________________________________________________
If you set out to do something, something else must be done first.
Post #1496017
Posted Wednesday, September 18, 2013 11:23 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 9:29 AM
Points: 214, Visits: 276
My biggest issue was that I assumed there wasn't more than one answer. I've gotten spoiled by the questions hinting that there is more than one answer.

To be honest, the first time I attempted this on paper I got it correct (I totally suck at basic math in my head... 4 + 4 = 9 right?) but I verified by running it through ssms.
Post #1496037
Posted Wednesday, September 18, 2013 1:49 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 12:04 PM
Points: 4,243, Visits: 3,320
You got me, Ron... Thanks anyway!
Post #1496111
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse