下表列出了SQLSERVER2000 的版本号:
RTM 2000.80.194.0
SQL Server 2000 SP1 2000.80.384.0
SQL Server 2000 SP2 2000.80.534.0
SQL Server 2000 SP3 2000.80.760.0
SQL Server 2000 SP3a 2000.80.760.0
SQL Server 2000 SP4 2000.8.00.2039
SQL Server 2000 SP1 2000.80.384.0
SQL Server 2000 SP2 2000.80.534.0
SQL Server 2000 SP3 2000.80.760.0
SQL Server 2000 SP3a 2000.80.760.0
SQL Server 2000 SP4 2000.8.00.2039
使用全局变量查询:
select @@version
如:
sp2 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)
或者
sp3 Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
sp3 Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
下列出了SQLSERVER2005的版本号:
SQL Server2005 RTM 9.00.1399 RTM
SQL Server2005 SP1 9.00.2047 Service Pack 1
SQL Server2005 SP2 9.00.3042 Service Pack 2 Original
9.00.3043 Service Pack 2 Refresh
SQL Server2005 SP1 9.00.2047 Service Pack 1
SQL Server2005 SP2 9.00.3042 Service Pack 2 Original
9.00.3043 Service Pack 2 Refresh
SQL Server2005 SP3 9.00.4035 Service Pack 3
也可使用
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') ,serverproperty('NumLicenses')
9.00.4035.00 SP3 Enterprise Edition 1000
转载于:https://blog.51cto.com/sqlnet/174778