sqlserver多版本查看版本号

复制代码 代码如下:

select serverproperty('productversion') ,serverproperty('productlevel') ,serverproperty('edition')
 

复制代码 代码如下:

select serverproperty('productversion') ,serverproperty('productlevel'),serverproperty('edition')
 

复制代码 代码如下:

select @@version
Microsoft SQL Server 2000 – 8.00.2039 (Intel X86)
May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Microsoft SQL Server 2005 – 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)