有两个语句:
PS:ProductVersion感觉较为实用一点
语句一:
SELECT @@VERSION
ps:结果太长了,不好解析,程序里面不实用
语句二:
SELECT
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('ProductLevel') AS ProductLevel,
SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('EngineEdition') AS EngineEdition;
PS:ProductVersion感觉较为实用一点
运行第一条会返回如下信息:Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)onWindows NT 6.0 (Build 6001: Service Pack 1)
运行第二条会返回如下信息:9.00.3042.00 SP2 Standard Edition (64-bit)