查看SQL SERVER版本的存储过程

查看SQL SERVER版本的存储过程

业务代码Profiler截得，自己加了层皮而已：

-- -----------------------------------------------------------------------

-- USP_VERSION

-- -----------------------------------------------------------------------

IF OBJECT_ID ( ' USP_VERSION ' ) IS NOT NULL
DROP PROC USP_VERSION
GO
CREATE PROC USP_VERSION
AS
BEGIN
SELECT @@VERSION
SELECT
CAST (serverproperty(N ' Servername ' ) AS sysname) AS [ Server_Name ] ,
' Server[@Name= ' + quotename ( CAST (serverproperty(N ' Servername ' ) AS sysname), '''' ) + ' ] ' AS [ Server_Urn ] ,
( @@microsoftversion / 0x1000000 ) & 0xff AS [ VersionMajor ] ,
( @@microsoftversion / 0x10000 ) & 0xff AS [ VersionMinor ] ,
@@microsoftversion & 0xffff AS [ BuildNumber ] ,
CAST (SERVERPROPERTY( ' IsSingleUser ' ) AS bit ) AS [ IsSingleUser ] ,
CAST (SERVERPROPERTY(N ' Edition ' ) AS sysname) AS [ Edition ]
ORDER BY [ Server_Name ] ASC
END
GO
EXEC USP_VERSION
GO

 

posted on 2011-01-05 23:12  陈伟强 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/chenwq/archive/2011/01/05/1926892.html