sql server 版本号（sql version number）

来源：互联网发布：淘宝买的东西在哪好评编辑：程序博客网时间：2024/05/18 20:10

8.0 -> sql server 2000
9.0 -> sql server 2005
10.0 -> sql server 2008
10.5 -> sql server 2008 R2
11.0 -> sql server 2012

12.0 -> sql server 2014

其它：select @@version

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)
   Jun 28 2012 08:36:30
   Copyright (c) Microsoft Corporation
   Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

(1 row(s) affected)

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
   Oct 19 2012 13:38:57
   Copyright (c) Microsoft Corporation
   Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

(1 row(s) affected)

0 0