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: Today @ 1:51 AM
Points: 1,127, Visits: 938
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 6:30 AM
Points: 9,410, Visits: 6,495
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
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Monday, June 10, 2013 4:11 AM
Points: 1,474, Visits: 2,344
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 @ 3:28 AM
Points: 3,166, Visits: 4,345
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


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 10:30 PM
Points: 464, Visits: 1,237
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: Monday, June 17, 2013 6:18 AM
Points: 691, Visits: 1,104
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-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, February 02, 2013 5:42 AM
Points: 190, Visits: 74
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: Monday, June 17, 2013 8:01 AM
Points: 989, Visits: 1,795
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 1,373, Visits: 896
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.




Oh no, we're toast! I've got this. *Keyboard clatter* Woah, how'd you do that? I'm a DBA...Booyah

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


SSC Eights!

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

Group: General Forum Members
Last Login: Yesterday @ 12:17 PM
Points: 856, Visits: 1,279
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