Post reply

SET Options - 2

  • December 4, 2012 at 8:19 pm

    #1565555

    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

  • December 4, 2012 at 9:27 pm

    #1565559

    Nice Question

    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

    #1565560

    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

  • December 4, 2012 at 11:17 pm

    #1565572

    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

    #1565606

    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

    #1565668

    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:

  • January 15, 2013 at 1:53 pm

    #1577530

    +1

  • January 24, 2013 at 12:43 am

    #1580387

    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.

  • February 13, 2013 at 4:35 pm

    #1587680

    +1 on the semi-colon being illegal after GO

  • April 5, 2013 at 8:59 am

    #1603944

    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

  • September 16, 2015 at 11:40 am

    #1827159

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

    CREATE TABLE [SELECT2] ("TABLE" int)

    Thanks.

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

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