Post reply

Restrict user to use (;) in queries

  • July 14, 2009 at 5:29 am

    #132046

    In sql server 2000 we use (;) for terminating the queries. Is it possible to replace (;) with (!) or we can restrict user not to use (;).Also i dont want touse 'GO'

    can we make any kind of setting in sql server

  • July 14, 2009 at 6:40 am

    #1024363

    In SQL 2000 the ; is not required, it's optional. Rumour has it that it may be required in a future version of SQL. It's a T-SQL language construct, so you can't change it any more than you can chance SELECT to RETRIEVE

    ; and GO do different things. ; is a statement terminator, GO is a batch terminator. Also GO is not a T-SQL command, but is used by the query tool to designate the end of a batch of statements to be sent to the server.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 14, 2009 at 9:05 am

    #1024466

    triple post.

    please see here and here . All posts have one answer so far, making it hard to tell where to continue if required...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

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