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

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

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 28, 2016 3:30 AM
Points: 1,182, Visits: 1,295
DugyC (9/7/2012)
What a fun question, thanks.

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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 2:06 AM
Points: 15,143, Visits: 13,032
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 SQLKover.

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

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:47 AM
Points: 2,594, Visits: 4,930
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 7, 2012 3:30 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:16 AM
Points: 5,028, Visits: 6,738
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 7, 2012 3:32 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 11:48 AM
Points: 1,459, Visits: 2,785
Michael Lysons (9/7/2012)
DugyC (9/7/2012)
What a fun question, thanks.

Actually, yeah it was - well said

+1


ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1355866
Posted Friday, September 7, 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: Thursday, June 12, 2014 4:19 AM
Points: 701, Visits: 1,145
Great question that shows a feature of the GO command that I only recently learned. Excellent!
Post #1355881
Posted Friday, September 7, 2012 4:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, March 31, 2016 6:28 AM
Points: 278, Visits: 99
Easy but tricky
Post #1355884
Posted Friday, September 7, 2012 6:15 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 11:44 AM
Points: 1,103, Visits: 2,101
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 7, 2012 6:57 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, February 22, 2016 7:16 AM
Points: 2,196, Visits: 1,654
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.




Everything is awesome!
Post #1355949
Posted Friday, September 7, 2012 7:03 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 8:17 AM
Points: 1,867, Visits: 3,093
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