UFN_SQLCLRVERSION

Return

Return Type
nvarchar(50)
Definition

Copy


create function dbo.UFN_SQLCLRVERSION()
returns nvarchar(50)
with execute as owner
as begin
    -- do work here and return a value

    return CONVERT(nvarchar(5), ASSEMBLYPROPERTY('Blackbaud.AppFx.Platform.SqlClr', 'VersionMajor')) + '.' + CONVERT(nvarchar(5), ASSEMBLYPROPERTY('Blackbaud.AppFx.Platform.SqlClr', 'VersionMinor')) + '.' + CONVERT(nvarchar(5), ASSEMBLYPROPERTY('Blackbaud.AppFx.Platform.SqlClr', 'VersionBuild')) + '.' + CONVERT(nvarchar(5), ASSEMBLYPROPERTY('Blackbaud.AppFx.Platform.SqlClr', 'VersionRevision'))
end