最後更新: 2017-04-05

Version

• 12.x.x        SQL Server 2014
• 11.0.x.x     SQL Server 2012
• 10.5.x.x     SQL Server 2008 R2
• 10.00.x.x   SQL Server 2008
• 9.00.x.x     SQL Server 2005
• 8.00.x.x     SQL Server 2000

對應目錄:

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER

Version:

CMD

Select @@version

Result:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   
Copyright (c) Microsoft Corporation  Enterprise Evaluation Edition (64-bit) 
on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

CMD

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

OUTPUT:

<1>

10.50.1600.1    RTM    Enterprise Evaluation Edition (64-bit)

<2>

10.50.4276.0    SP2    Standard Edition (64-bit)

CU = 累計更新: 包含所有先前到最新的重大隨選 Hotfix 的彙總套件更新
RTM = 通常表示「釋出以進行製造」
    例如在 SQL Server 的產品內容中，RTM 表示產品沒有任何可套用的 Service Pack 或 Hotfix。
   

download/get the latest service packs:
http://technet.microsoft.com/en-us/sqlserver/ff398089

Serice Patch

SQL Version:

SQL Server 2008

SP3              10.00.5500.00
SP2              10.00.4000.00

SQL Server 2008 R2

• SP3              10.50.6000
• SP2              10.50.4000
• SP1              10.50.2500

2016 Express

LocalDB (SqlLocalDB)

LocalDB is a lightweight version of Express that has all its programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites. Use this if you need a simple way to create and work with databases from code. It can be bundled with Application and Database Development tools like Visual Studio and or embedded with an application that needs local databases.

Express (SQLEXPR)

Express edition includes the SQL Server database engine only.

Best suited to accept remote connections or administer remotely.

Express with Advanced Services (SQLEXPRADV)

This package contains Full Text Search and Reporting Services features in addition to SQL Database Engine.