June 4, 2012

sp_MSSQLDMO90_version (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData




create procedure sys.sp_MSSQLDMO90_version
-- Values for this are same as @@microsoftversion --
-- @@microsoftversion format is 0xaaiibbbb (aa = major, ii = minor, bb[bb] = build #) --
declare @i int
select @i = 0x09000000 -- Must be in hex! --

-- Select the numeric value, and a conversion to make it readable --
select N'Microsoft SQLDMO Scripts' = @i, N'Version' = convert(binary(4), @i)

No comments:

Post a Comment

Total Pageviews