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

SET Options - 2 Expand / Collapse
Author
Message
Posted Tuesday, December 04, 2012 8:19 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:47 AM
Points: 2,120, Visits: 5,134
okbangas (12/3/2012)
Wrong answer marked as correct. SQL Server will return the following error message:
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near ';'.

Semicolon is not allowed after go.


+1
Post #1392768
Posted Tuesday, December 04, 2012 9:27 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 17, 2013 2:58 AM
Points: 245, Visits: 158

Nice Question

That ";" made a small black mark on the question :)


There is no Wrong time to do a Right thing :)
Post #1392778
Posted Tuesday, December 04, 2012 9:28 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:46 AM
Points: 1,371, Visits: 1,547
Good Question Ron. Thanks for posting. Its always good to revise our basics

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1392779
Posted Tuesday, December 04, 2012 11:17 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 14, 2014 11:50 PM
Points: 1,867, Visits: 2,275
nice basic question neglecting ':' part


_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1392797
Posted Wednesday, December 05, 2012 1:57 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, April 17, 2014 7:26 AM
Points: 1,658, Visits: 6,002
Shame about the endless complaints about the semi-colon (does nobody ever read the thread before adding to it?)

The easy way to have avoided confusion as to whether the syntax error was intended is to do what I did, and fail to notice it was there
Post #1392835
Posted Wednesday, December 05, 2012 4:09 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
Toreador (12/5/2012)
Shame about the endless complaints about the semi-colon (does nobody ever read the thread before adding to it?)

The easy way to have avoided confusion as to whether the syntax error was intended is to do what I did, and fail to notice it was there


Post #1392908
Posted Tuesday, January 15, 2013 1:53 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 8:54 PM
Points: 606, Visits: 151
+1
Post #1407485
Posted Thursday, January 24, 2013 12:43 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, March 17, 2014 7:22 AM
Points: 228, Visits: 211
nice one.... thanks for question.... we can create table name with double quotes.... and coulumn name also....





manikandan.ps
Go as fast as possible.


Manik
You cannot get to the top by sitting on your bottom.
Post #1410942
Posted Wednesday, February 13, 2013 4:35 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 05, 2014 12:27 PM
Points: 287, Visits: 276
+1 on the semi-colon being illegal after GO
Post #1419771
Posted Friday, April 05, 2013 8:59 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:17 AM
Points: 636, Visits: 508
Oops; those damned semi-colons get in everywhere;!!

Luckily I chose to ignore it after thinking "they wouldn't do that, would they??"



MCITP
MCTS - E-Business Card
Twitter: WWDMark

Try not! Do or do not, there is no try

email: info@weekendwebdesign.co.uk
Personal Website: www.markallen-online.co.uk
Business Website: www.weekendwebdesign.co.uk
Post #1439269
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse