To semi-colon or not to semi-colon

Do you need to end your T-SQL statements with a semi-colon (;)?
No, at least not yet. As stated in the following web page (http://msdn.microsoft.com/en-us/library/ms143729.aspx) "Not ending Transact-SQL statements with a semi-colon." will be replaced by "End Transact-SQL statements with a semi-colon ( ; )." in
future versions...

Is it a good practice to end your statements with a semi-colon?
Yes, because:
- it will be mandatory in the future.
- you need to use it with CTE.(where the preceeding statement needs to end with a ";")
- you need to end MERGE statements with a ";"

Community Day 2009

Third Edition of Microsoft Community Day, a networking and knowledge sharing event.
Register yourself and be there!

Architect Forum - May 6th 2009

The forum will be on Security and Identity Lifecycle Management.
More information on the Architects Rule! blog here...

SQL Server 2008 SP1 Released

Microsoft has released their final version of Service Pack 1 for SQL Server 2008, less than a year after the Release of SQL Server 2008.

No new features have been added to SP1, byt there are some improvements on usabiltiy.

SQL Server 2008 SP1 is availalable for download here!