[转]SQL Server 版本一覽

- 日理万妓 2021-11-26 17:50 195阅读 0赞

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

<table> 
 <tbody> 
 <tr> 
 <td style="border-bottom:#000000 1px solid;text-align:center;border-left:#000000 1px solid;font-size:medium;border-top:#000000 1px solid;border-right:#000000 1px solid;" colspan="3">SQL Server 2008</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.27.57</td> 
 <td><a href="http://support.microsoft.com/kb/977443/en-us" rel="nofollow">SQL Server 2008 SP1 CU6</a></td> 
 <td style="text-align:center;">18 Jan 2010</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.2746</td> 
 <td><a href="http://support.microsoft.com/kb/975977/en-us" rel="nofollow">SQL Server 2008 SP1 CU5</a></td> 
 <td style="text-align:center;">24 Nov 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.2734</td> 
 <td><a href="http://support.microsoft.com/kb/973602/en-us" rel="nofollow">SQL Server 2008 SP1 CU4</a></td> 
 <td style="text-align:center;">22 Sept 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.2723</td> 
 <td><a href="http://support.microsoft.com/default.aspx/kb/971491/en-us" rel="nofollow">SQL Server 2008 SP1 CU3</a></td> 
 <td style="text-align:center;">21 July 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.2714</td> 
 <td><a href="http://support.microsoft.com/kb/970315" rel="nofollow">SQL Server 2008 SP1 CU2</a></td> 
 <td style="text-align:center;">18 May 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.2710</td> 
 <td><a href="http://support.microsoft.com/kb/969099" rel="nofollow">SQL Server 2008 SP1 CU1</a></td> 
 <td style="text-align:center;">16 Apr 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.2531</td> 
 <td><a href="http://www.microsoft.com/downloads/details.aspx?displaylang=en&amp;FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19" rel="nofollow">SQL Server 2008 SP1</a></td> 
 <td style="text-align:center;">7 Apr 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.1828</td> 
 <td><a href="http://support.microsoft.com/kb/977444/en-us" rel="nofollow">SQL Server 2008 RTM CU9</a></td> 
 <td style="text-align:center;">18 Jan 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.1823</td> 
 <td><a href="http://support.microsoft.com/kb/975976/en-us" rel="nofollow">SQL Server 2008 RTM CU8</a></td> 
 <td style="text-align:center;">16 Nov 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.1818</td> 
 <td><a href="http://support.microsoft.com/kb/973601/en-us" rel="nofollow">SQL Server 2008 RTM CU7</a></td> 
 <td style="text-align:center;">21 Sept 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.1812</td> 
 <td><a href="http://support.microsoft.com/kb/971490/en-us" rel="nofollow">SQL Server 2008 RTM CU6</a></td> 
 <td style="text-align:center;">21 July 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.1806</td> 
 <td><a href="http://support.microsoft.com/kb/969531/en-us" rel="nofollow">SQL Server 2008 RTM CU5</a></td> 
 <td style="text-align:center;">18 May 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.1798</td> 
 <td><a href="http://support.microsoft.com/kb/963036/en-us" rel="nofollow">SQL Server 2008 RTM CU4</a></td> 
 <td style="text-align:center;">17 Mar 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.1787</td> 
 <td><a href="http://support.microsoft.com/kb/960484" rel="nofollow">SQL Server 2008 RTM CU3</a></td> 
 <td style="text-align:center;">19 Jan 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.1779</td> 
 <td><a href="http://support.microsoft.com/kb/958186/" rel="nofollow">SQL Server 2008 RTM CU2</a></td> 
 <td style="text-align:center;">17 Nov 2008</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.1763</td> 
 <td><a href="http://support.microsoft.com/kb/956717/" rel="nofollow">SQL Server 2008 RTM CU1</a></td> 
 <td style="text-align:center;">22 Sept 2008</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">10.00.1600</td> 
 <td>SQL Server 2008 RTM</td> 
 <td style="text-align:center;">6 Aug 2008</td> 
 </tr> 
 <tr> 
 <td style="border-bottom:#000000 1px solid;text-align:center;border-left:#000000 1px solid;font-size:medium;border-top:#000000 1px solid;border-right:#000000 1px solid;" colspan="3">SQL Server 2005</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.4285</td> 
 <td><a href="http://support.microsoft.com/kb/978915/en-us" rel="nofollow">SQL Server 2005 SP3 CU8</a></td> 
 <td>16 Feb 2010</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.4273</td> 
 <td><a href="http://support.microsoft.com/kb/976951/en-us" rel="nofollow">SQL Server 2005 SP3 CU7</a></td> 
 <td>21 Dec 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.4266</td> 
 <td><a href="http://support.microsoft.com/kb/974648/en-us" rel="nofollow">SQL Server 2005 SP3 CU6</a></td> 
 <td>19 Oct 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.4230</td> 
 <td><a href="http://support.microsoft.com/kb/972511/en-us" rel="nofollow">SQL Server 2005 SP3 CU5</a></td> 
 <td>17 Aug 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.4226</td> 
 <td><a href="http://support.microsoft.com/default.aspx/kb/970279/en-us" rel="nofollow">SQL Server 2005 SP3 CU4</a></td> 
 <td>16 June 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.4220</td> 
 <td><a href="http://support.microsoft.com/kb/967909/en-us" rel="nofollow">SQL Server 2005 SP3 CU3</a></td> 
 <td>21 Apr 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.4211</td> 
 <td><a href="http://support.microsoft.com/kb/961930/en-us" rel="nofollow">SQL Server 2005 SP3 CU2</a></td> 
 <td>17 Feb 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.4207</td> 
 <td><a href="http://support.microsoft.com/kb/959195/en-us" rel="nofollow">SQL Server 2005 SP3 CU1</a></td> 
 <td>20 Dec 2008</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.4053</td> 
 <td><a href="http://support.microsoft.com/kb/970892" rel="nofollow">SQL Server 2005 SP3 GDR</a> (Security Update)</td> 
 <td>13 Oct 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.4035</td> 
 <td><a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&amp;displaylang=en" rel="nofollow">SQL Server 2005 SP3</a></td> 
 <td>16 Dec 2008</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3356</td> 
 <td><a href="http://support.microsoft.com/kb/976952/en-us" rel="nofollow">SQL Server 2005 SP2 CU17</a></td> 
 <td>21 Dec 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3355</td> 
 <td><a href="http://support.microsoft.com/kb/974647/en-us" rel="nofollow">SQL Server 2005 SP2 CU16</a></td> 
 <td>19 Oct 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3330</td> 
 <td><a href="http://support.microsoft.com/kb/972510/en-us" rel="nofollow">SQL Server 2005 SP2 CU15</a></td> 
 <td>18 Aug 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3328</td> 
 <td><a href="http://support.microsoft.com/kb/970278/en-us" rel="nofollow">SQL Server 2005 SP2 CU14</a></td> 
 <td>16 June 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3225</td> 
 <td><a href="http://support.microsoft.com/kb/967908/en-us" rel="nofollow">SQL Server 2005 SP2 CU13</a></td> 
 <td>21 Apr 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3315</td> 
 <td><a href="http://support.microsoft.com/kb/962970/en-us" rel="nofollow">SQL Server 2005 SP2 CU12</a></td> 
 <td>17 Feb 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3310</td> 
 <td><a href="http://support.microsoft.com/kb/959420" rel="nofollow">SQL Server 2005 Security Update</a></td> 
 <td>10 Feb 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3301</td> 
 <td>SQL Server 2005 SP2 CU11</td> 
 <td>15 Dec 2008</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3294</td> 
 <td><a href="http://support.microsoft.com/kb/956854/" rel="nofollow">SQL Server 2005 SP2 CU10</a></td> 
 <td>20 Oct 2008</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3282</td> 
 <td><a href="http://support.microsoft.com/kb/953752/" rel="nofollow">SQL Server 2005 SP2 CU9</a></td> 
 <td>18 Aug 2008</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3257</td> 
 <td><a href="http://support.microsoft.com/kb/951217/" rel="nofollow">SQL Server 2005 SP2 CU8</a></td> 
 <td>16 June 2008</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3239</td> 
 <td><a href="http://support.microsoft.com/kb/949095/" rel="nofollow">SQL Server 2005 SP2 CU7</a></td> 
 <td>14 April 2008</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3233</td> 
 <td><a href="http://support.microsoft.com/kb/948108/" rel="nofollow">SQL Server 2005 QFE Security Update</a></td> 
 <td>8 July 2008</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3228</td> 
 <td><a href="http://support.microsoft.com/kb/946608/" rel="nofollow">SQL Server 2005 SP2 CU6</a></td> 
 <td>18 Feb 2008</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3215</td> 
 <td><a href="http://support.microsoft.com/kb/943656/" rel="nofollow">SQL Server 2005 SP2 CU5</a></td> 
 <td>17 Dec 2007</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3200</td> 
 <td><a href="http://support.microsoft.com/kb/941450/" rel="nofollow">SQL Server 2005 SP2 CU4</a></td> 
 <td>15 Oct 2007</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3186</td> 
 <td><a href="http://support.microsoft.com/kb/939537/" rel="nofollow">SQL Server 2005 SP2 CU3</a></td> 
 <td>20 Aug 2007</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3175</td> 
 <td><a href="http://support.microsoft.com/kb/936305/" rel="nofollow">SQL Server 2005 SP2 CU2</a></td> 
 <td>28 June 2007</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3161</td> 
 <td>SQL Server 2005 SP2 Cumulative Update 1 (CU1)</td> 
 <td>&nbsp;</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3152</td> 
 <td><a href="http://support.microsoft.com/kb/933097/" rel="nofollow">SQL Server 2005 SP2 Cumulative Hotfix</a> </td> 
 <td>7 Mar 2007</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3077</td> 
 <td><a href="http://support.microsoft.com/default.aspx/kb/960089" rel="nofollow">SQL Server 2005 Security Update</a></td> 
 <td>10 Feb 2009</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3054</td> 
 <td><a href="http://support.microsoft.com/kb/934458" rel="nofollow">KB934458</a> - Also read <a href="http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx" rel="nofollow">Bob Ward's post on SP2</a>.</td> 
 <td>5-Apr-07</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3042.01</td> 
 <td><a href="http://www.sqlteam.com/article/microsoft-releases-updated-sql-server-2005-sp2" rel="nofollow">SQL Server 2005 "SP2a"</a></td> 
 <td>5-Mar-07</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.3042</td> 
 <td>SQL Server 2005 SP2</td> 
 <td>Feb-07</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.2047</td> 
 <td>SQL Server 2005 SP1</td> 
 <td>&nbsp;</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">9.00.1399</td> 
 <td>SQL Server 2005 RTM</td> 
 <td>Nov-05</td> 
 </tr> 
 <tr> 
 <td style="border-bottom:#000000 1px solid;text-align:center;border-left:#000000 1px solid;font-size:medium;border-top:#000000 1px solid;border-right:#000000 1px solid;" colspan="3">SQL Server 2000</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">8.00.2039</td> 
 <td>SQL Server 2000 SP4</td> 
 <td>&nbsp;</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">8.00.760</td> 
 <td>SQL Server 2000 SP3</td> 
 <td>&nbsp;</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">8.00.534</td> 
 <td>SQL Server 2000 SP2</td> 
 <td>30 Nov 2001</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">8.00.384</td> 
 <td>SQL Server 2000 SP1</td> 
 <td>&nbsp;</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">8.00.194</td> 
 <td>SQL Server 2000 RTM</td> 
 <td>&nbsp;</td> 
 </tr> 
 <tr> 
 <td style="border-bottom:#000000 1px solid;text-align:center;border-left:#000000 1px solid;font-size:medium;border-top:#000000 1px solid;border-right:#000000 1px solid;" colspan="3">SQL Server 7</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">7.00.1063</td> 
 <td>SQL Server 7.0 SP4</td> 
 <td>&nbsp;</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">7.00.961</td> 
 <td>SQL Server 7.0 SP3</td> 
 <td>15 Dec 2000</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">7.00.842</td> 
 <td>SQL Server 7.0 SP2</td> 
 <td>20 Mar 2000</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">7.00.699</td> 
 <td>SQL Server 7.0 SP1</td> 
 <td>July 1999</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">7.00.623</td> 
 <td>SQL Server 7.0 / MSDE 1.0 RTM</td> 
 <td>&nbsp;</td> 
 </tr> 
 <tr> 
 <td style="border-bottom:#000000 1px solid;text-align:center;border-left:#000000 1px solid;font-size:medium;border-top:#000000 1px solid;border-right:#000000 1px solid;" colspan="3">SQL Server 6.5</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">6.50.416</td> 
 <td>SQL Server 6.5 with Service Pack 5a</td> 
 <td>&nbsp;</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">6.50.415</td> 
 <td>SQL Server 6.5 with Service Pack 5</td> 
 <td>&nbsp;</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">6.50.281</td> 
 <td>SQL Server 6.5 with Service Pack 4</td> 
 <td>&nbsp;</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">6.50.258</td> 
 <td>SQL Server 6.5 with Service Pack 3</td> 
 <td>&nbsp;</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">6.50.240</td> 
 <td>SQL Server 6.5 with Service Pack 2</td> 
 <td>&nbsp;</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">6.50.213</td> 
 <td>SQL Server 6.5 with Service Pack 1</td> 
 <td>&nbsp;</td> 
 </tr> 
 <tr> 
 <td style="text-align:center;">6.50.201</td> 
 <td>SQL Server 6.5 RTM</td> 
 <td>&nbsp;</td> 
 </tr> 
 </tbody> 
</table>

*  查詢版本的指令

> 查詢結果如下(以我的環境為例):
> 
> > 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:

转载于:https://www.cnblogs.com/frankychan/archive/2012/02/29/2373417.html