Tuesday, March 20, 2012

;?

using ';' is just a demarkation of T-SQL statement.
And its very much different from a GO statement.
GO is for end of a batch and is not something understood by T-SQL Engine but
only by your QA.
And you don't get any performance benifit by adding or removing the ';'
But its better to add the ';', since readability improves anyways and few of
the new features in SQL Server 2005, like the service broker mandates use of
';'. So better to remember using ';' in general than rememberting where all
to use it :)
--
-Omnibuzz (The SQL GC)
http://omnibuzz-sql.blogspot.com/>> But its better to add the ';', since readability improves anyways and few
Another instance in SQL 2005 is when you use WITH CTE where it is not the
first statement of the batch. Unless the preceding statement is terminated
with a semi-colon you'll get an error.
Anith|||...unless enclosed in a BEGIN...END block. ;)
There are alternatives to semi-colons.
ML
http://milambda.blogspot.com/

No comments:

Post a Comment