SET Options - 2

Question

SET Options - 2

Viewing 11 posts - 31 through 40 (of 40 total)

You must be logged in to reply to this topic. Login to reply

prvmine SSCertifiable Points: 7007 More actions · Answer 1

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

Samith C Mr or Mrs. 500 Points: 519 More actions · Answer 2

Nice Question

That ";" made a small black mark on the question 🙂

[font="Verdana"] There is no Wrong time to do a Right thing 🙂 [/font]

Lokesh Vij SSChampion Points: 10836 More actions · Answer 3

Good Question Ron. Thanks for posting. Its always good to revise our basics 🙂

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

kapil_kk SSC-Insane Points: 21316 More actions · Answer 4

nice basic question neglecting ':' part

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Toreador SSChampion Points: 11368 More actions · Answer 5

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 🙂

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 6

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 🙂

:doze:

asifkareem Ten Centuries Points: 1089 More actions · Answer 7

asifkareem

Ten Centuries

Points: 1089

January 15, 2013 at 1:53 pm

#1577530

+1

manik_anu SSCrazy Points: 2377 More actions · Answer 8

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.

Andre Ranieri SSCrazy Points: 2819 More actions · Answer 9

Andre Ranieri

SSCrazy

Points: 2819

February 13, 2013 at 4:35 pm

#1587680

+1 on the semi-colon being illegal after GO

WWDMark Hall of Fame Points: 3157 More actions · Answer 10

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: http://markallen.co.uk/
Business Website: https://www.weekendwebdesign.co.uk

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 11

You can even run like this:- (using angular brackets)

CREATE TABLE [SELECT2] ("TABLE" int)

Thanks.