Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, March 1, 2011 3:14 AM
Points: 11, Visits: 45
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


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:06 AM
Points: 42,468, Visits: 35,537
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 2008, MVP
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:34 PM
Points: 7,040, Visits: 12,966
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
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