IliaJ on .NET

I've read today the SQL Server 2008 Books Online and found the following statement in the Transact-SQL Syntax Convention:

; - Transact-SQL statement terminator. Although the semicolon is not required for most statements in this version of SQL Server, it will be required in a future version.

If you plan to use or sell your software for longer time, you should think about starting to use semicolons in your code today.

Tags:
Categories: SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008 | SQL Server 2008

Do you really have the released version of Microsoft SQL Server 2008?

If you open the Help à About Dialog in SQL Server Management Studio, you will see the following window

What does it mean: 10.0.1600.22 ((SQL_PreRelease).080709-1414)? Is this a pre-release software? Fortunately, no.

According to Microsoft you do have the RTM version SQL Server 2008 10.0.1660.22. And the string SQL_PreRelease is merely an internal label used for the build management. So, please use the official "SQL"-way to get this information und simply run:

select @@version

in SQL Server Management Studio to see

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)...

Tags: sql server
Categories: SQL Server 2008