原文 - http://www.sqlteam.com/article/sql-server-versions

　

SQL Server 版本一覽 (2010/1/18為止)

　

SQL Server 2008
10.00.27.57 SQL Server 2008 SP1 CU6 18 Jan 2010
10.00.2746 SQL Server 2008 SP1 CU5 24 Nov 2009
10.00.2734 SQL Server 2008 SP1 CU4 22 Sept 2009
10.00.2723 SQL Server 2008 SP1 CU3 21 July 2009
10.00.2714 SQL Server 2008 SP1 CU2 18 May 2009
10.00.2710 SQL Server 2008 SP1 CU1 16 Apr 2009
10.00.2531 SQL Server 2008 SP1 7 Apr 2009
10.00.1828 SQL Server 2008 RTM CU9 18 Jan 2009
10.00.1823 SQL Server 2008 RTM CU8 16 Nov 2009
10.00.1818 SQL Server 2008 RTM CU7 21 Sept 2009
10.00.1812 SQL Server 2008 RTM CU6 21 July 2009
10.00.1806 SQL Server 2008 RTM CU5 18 May 2009
10.00.1798 SQL Server 2008 RTM CU4 17 Mar 2009
10.00.1787 SQL Server 2008 RTM CU3 19 Jan 2009
10.00.1779 SQL Server 2008 RTM CU2 17 Nov 2008
10.00.1763 SQL Server 2008 RTM CU1 22 Sept 2008
10.00.1600 SQL Server 2008 RTM 6 Aug 2008
SQL Server 2005
9.00.4285 SQL Server 2005 SP3 CU8 16 Feb 2010
9.00.4273 SQL Server 2005 SP3 CU7 21 Dec 2009
9.00.4266 SQL Server 2005 SP3 CU6 19 Oct 2009
9.00.4230 SQL Server 2005 SP3 CU5 17 Aug 2009
9.00.4226 SQL Server 2005 SP3 CU4 16 June 2009
9.00.4220 SQL Server 2005 SP3 CU3 21 Apr 2009
9.00.4211 SQL Server 2005 SP3 CU2 17 Feb 2009
9.00.4207 SQL Server 2005 SP3 CU1 20 Dec 2008
9.00.4053 SQL Server 2005 SP3 GDR (Security Update) 13 Oct 2009
9.00.4035 SQL Server 2005 SP3 16 Dec 2008
9.00.3356 SQL Server 2005 SP2 CU17 21 Dec 2009
9.00.3355 SQL Server 2005 SP2 CU16 19 Oct 2009
9.00.3330 SQL Server 2005 SP2 CU15 18 Aug 2009
9.00.3328 SQL Server 2005 SP2 CU14 16 June 2009
9.00.3225 SQL Server 2005 SP2 CU13 21 Apr 2009
9.00.3315 SQL Server 2005 SP2 CU12 17 Feb 2009
9.00.3310 SQL Server 2005 Security Update 10 Feb 2009
9.00.3301 SQL Server 2005 SP2 CU11 15 Dec 2008
9.00.3294 SQL Server 2005 SP2 CU10 20 Oct 2008
9.00.3282 SQL Server 2005 SP2 CU9 18 Aug 2008
9.00.3257 SQL Server 2005 SP2 CU8 16 June 2008
9.00.3239 SQL Server 2005 SP2 CU7 14 April 2008
9.00.3233 SQL Server 2005 QFE Security Update 8 July 2008
9.00.3228 SQL Server 2005 SP2 CU6 18 Feb 2008
9.00.3215 SQL Server 2005 SP2 CU5 17 Dec 2007
9.00.3200 SQL Server 2005 SP2 CU4 15 Oct 2007
9.00.3186 SQL Server 2005 SP2 CU3 20 Aug 2007
9.00.3175 SQL Server 2005 SP2 CU2 28 June 2007
9.00.3161 SQL Server 2005 SP2 Cumulative Update 1 (CU1)  
9.00.3152 SQL Server 2005 SP2 Cumulative Hotfix 7 Mar 2007
9.00.3077 SQL Server 2005 Security Update 10 Feb 2009
9.00.3054 KB934458 - Also read Bob Ward's post on SP2. 5-Apr-07
9.00.3042.01 SQL Server 2005 "SP2a" 5-Mar-07
9.00.3042 SQL Server 2005 SP2 Feb-07
9.00.2047 SQL Server 2005 SP1  
9.00.1399 SQL Server 2005 RTM Nov-05
SQL Server 2000
8.00.2039 SQL Server 2000 SP4  
8.00.760 SQL Server 2000 SP3  
8.00.534 SQL Server 2000 SP2 30 Nov 2001
8.00.384 SQL Server 2000 SP1  
8.00.194 SQL Server 2000 RTM  
SQL Server 7
7.00.1063 SQL Server 7.0 SP4  
7.00.961 SQL Server 7.0 SP3 15 Dec 2000
7.00.842 SQL Server 7.0 SP2 20 Mar 2000
7.00.699 SQL Server 7.0 SP1 July 1999
7.00.623 SQL Server 7.0 / MSDE 1.0 RTM  
SQL Server 6.5
6.50.416 SQL Server 6.5 with Service Pack 5a  
6.50.415 SQL Server 6.5 with Service Pack 5  
6.50.281 SQL Server 6.5 with Service Pack 4  
6.50.258 SQL Server 6.5 with Service Pack 3  
6.50.240 SQL Server 6.5 with Service Pack 2  
6.50.213 SQL Server 6.5 with Service Pack 1  
6.50.201 SQL Server 6.5 RTM  
  • 查詢版本的指令 
Select @@version

查詢結果如下(以我的環境為例):

Microsoft SQL Server 2005 - 9.00.3077.00 (Intel X86)

Dec 17 2008 15:19:45

Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

　
  • 查詢相關資料的系統 sp: 
exec master..xp_msver

 

arrow
arrow
    全站熱搜

    cbw0731 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄