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 7, 2012 3:12 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:24 AM
Points: 1,156, Visits: 1,133
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:15 AM
Points: 13,635, Visits: 11,504
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 7, 2012 3:21 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:20 AM
Points: 2,111, Visits: 3,708
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 4:13 AM
Points: 4,156, Visits: 5,549
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:43 PM
Points: 1,053, Visits: 2,354
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: Wednesday, July 16, 2014 6:22 AM
Points: 271, Visits: 96
Easy but tricky
Post #1355884
Posted Friday, September 7, 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: Yesterday @ 12:51 PM
Points: 985, Visits: 1,841
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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:54 AM
Points: 1,987, Visits: 1,492
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:53 AM
Points: 1,419, Visits: 2,440
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