业务代码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
-- 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