Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Restrict user to use (;) in queries Expand / Collapse
Posted Tuesday, July 14, 2009 5:29 AM


Group: General Forum Members
Last Login: Thursday, March 31, 2016 4:30 AM
Points: 15, Visits: 48
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
Post #752586
Posted Tuesday, July 14, 2009 6:40 AM



Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
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

Post #752630
Posted Tuesday, July 14, 2009 9:05 AM



Group: General Forum Members
Last Login: Wednesday, February 10, 2016 11:50 AM
Points: 6,897, Visits: 13,559
triple post.
please see here and here . All posts have one answer so far, making it hard to tell where to continue if required...

A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #752753
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse