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