How to determine which version of SQL Server is running using T-SQL

Question

I need help using T-SQL to determine the SQL Server startup version and the execution of various sets of code based on SQL Server 2000 or Sql Server 2008 weather.

Answer 1

SELECT @@VERSION? 

Or one of the SERVERPROPERTY parameters?

Answer 2

  SELECT SERVERPROPERTY('productversion') , SERVERPROPERTY ('productlevel') , SERVERPROPERTY ('edition') 

Answer 3

@@ VERSION / SERVERPROPERTY

But you should also check

 exec sp_dbcmptlevel 'dbname' 

To ensure that a particular function works at the database compatibility level.

Answer 4

Just query the database - there is a @@VERSION property:

 SELECT @@VERSION 

Returns the version, processor architecture, build date, and operating system for the current installation of SQL Server.

As mentioned on the page, since all this data is returned in one varchar, you can use the SERVERPROPERTY function to retrieve only the version

 SELECT SERVERPROPERTY('ProductVersion') 

Answer 5

 SELECT SERVERPROPERTY('productversion') 

The numbers before the first period will give you the basic version: 10 = 2008, 9 = 2005, 8 = 2000.

Answer 6

Use to get the SQL version of the server:

 SELECT SERVERPROPERTY('ProductVersion') GO 

Or for a more detailed command

 SELECT @@VERSION GO 

Also in here you can find a list of version numbers of versions

Answer 7

SELECT SERVERPROPERTY ('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Answer 8

 EXEC[MASTER].SYS.[XP_MSVER]--To get the server version