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

GO Part 1 Expand / Collapse
Author
Message
Posted Friday, September 07, 2012 3:12 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, April 11, 2014 1:38 AM
Points: 1,144, Visits: 1,050
DugyC (9/7/2012)
What a fun question, thanks.

Actually, yeah it was - well said
Post #1355846
Posted Friday, September 07, 2012 3:21 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:31 PM
Points: 12,239, Visits: 9,212
Michael Lysons (9/7/2012)

Then again, "Is GO x valid T-SQL?" would be a boring question.



And the answer is surprisingly: no.
GO is not a TSQL statement, but a batch terminator recognised by sqlcmd, osql and SSMS.

GO (Transact-SQL)




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1355852
Posted Friday, September 07, 2012 3:21 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, April 10, 2014 10:18 AM
Points: 1,769, Visits: 2,800
L' Eomot Inversé (9/7/2012)
1*2*2*2*2*2 = 6


It does equal 6! At least, that's my excuse.
Post #1355853
Posted Friday, September 07, 2012 3:30 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 @ 12:19 PM
Points: 3,694, Visits: 4,828
Lesson learned: Don't answer until after the first cup of strong coffee...

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1355861
Posted Friday, September 07, 2012 3:32 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 @ 2:33 AM
Points: 673, Visits: 1,554
Michael Lysons (9/7/2012)
DugyC (9/7/2012)
What a fun question, thanks.

Actually, yeah it was - well said

+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 #1355866
Posted Friday, September 07, 2012 4:27 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: Wednesday, April 09, 2014 10:34 AM
Points: 701, Visits: 1,140
Great question that shows a feature of the GO command that I only recently learned. Excellent!
Post #1355881
Posted Friday, September 07, 2012 4:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 09, 2013 7:57 AM
Points: 267, Visits: 93
Easy but tricky
Post #1355884
Posted Friday, September 07, 2012 6:15 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, October 04, 2013 12:06 PM
Points: 989, Visits: 1,804
What's really bad is understanding the question correctly and screwing up the loop counts because it is early in the morning. I counted the 5 loops but forgot to include the first run and ended up with 16. Once I saw it was wrong I recounted and hit my forehead with my palm.
Post #1355937
Posted Friday, September 07, 2012 6:57 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 11:49 AM
Points: 1,727, Visits: 1,254
jeff.mason (9/7/2012)
What's really bad is understanding the question correctly and screwing up the loop counts because it is early in the morning. I counted the 5 loops but forgot to include the first run and ended up with 16. Once I saw it was wrong I recounted and hit my forehead with my palm.


+ 1

- 1 (palm to forehead)

Thank you for the great question, too bad I couldn't end Friday with that point. I guess I should have learned my lesson by trying to answer QotD this early before caffeine.




Yeah, uh huh, you know what it is. Everything I do, I do it big

Post #1355949
Posted Friday, September 07, 2012 7:03 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:33 AM
Points: 1,196, Visits: 2,039
Ugh, I've got to stop answering these questions first thing in the morning.
Great question though!
Post #1355951
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse