December 4, 2012 at 8:19 pm
okbangas (12/3/2012)Wrong answer marked as correct. SQL Server will return the following error message:Msg 102, Level 15, State 1, Line 5Incorrect syntax near ';'.Semicolon is not allowed after go.
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near ';'.
Semicolon is not allowed after go.
Mr or Mrs. 500
December 4, 2012 at 9:27 pm
That ";" made a small black mark on the question 🙂
[font="Verdana"] There is no Wrong time to do a Right thing 🙂 [/font]
December 4, 2012 at 9:29 pm
Good Question Ron. Thanks for posting. Its always good to revise our basics 🙂
~ Lokesh Vij
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
December 4, 2012 at 11:17 pm
nice basic question neglecting ':' part
_______________________________________________________________To get quick answer follow this link:http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 5, 2012 at 1:57 am
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 🙂
December 5, 2012 at 4:09 am
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 🙂
January 15, 2013 at 1:53 pm
January 24, 2013 at 12:43 am
nice one.... thanks for question.... we can create table name with double quotes.... and coulumn name also....:-)
Go as fast as possible.
ManikYou cannot get to the top by sitting on your bottom.
February 13, 2013 at 4:35 pm
+1 on the semi-colon being illegal after GO
Hall of Fame
April 5, 2013 at 8:59 am
Oops; those damned semi-colons get in everywhere;!!
Luckily I chose to ignore it after thinking "they wouldn't do that, would they??" 😀
email: firstname.lastname@example.orgPersonal Website: http://markallen.co.uk/Business Website: https://www.weekendwebdesign.co.uk
September 16, 2015 at 11:40 am
You can even run like this:- (using angular brackets)
CREATE TABLE [SELECT2] ("TABLE" int)
Viewing 11 posts - 31 through 41 (of 41 total)
You must be logged in to reply to this topic. Login to reply