[dba-SQLServer] Semicolon Statement Terminator Enforced in Denali?

Alan Lawhon lawhonac at hiwaay.net
Thu Jan 5 16:57:59 CST 2012


I'm reading the SQL Server 2008 R2 BOL and come across this documentation
for batches.

 

<begin>

A batch is a group of one or more Transact-SQL statements sent at the same
time from an application to SQL Server for execution. SQL Server compiles
the statements of a batch into a single executable unit, called an execution
plan. The statements in the execution plan are then executed one at a time.

Each Transact-SQL statement should be terminated with a semicolon. This
requirement is not enforced, but the ability to end a statement without a
semicolon is deprecated and may be removed in a future version of Microsoft
SQL Server.

<end>

 

I've been writing most of my queries without using the semicolon character
to terminate statements.  Does the new version (i.e. SQL Server "Denali")
rigidly enforce termination of T-SQL statements with the semicolon
character?  Just curious.

 

Alan C. Lawhon

 



More information about the dba-SQLServer mailing list