UFN_SMARTFIELD_GETDESCRIPTION

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_SMARTFIELD_GETDESCRIPTION(@ID uniqueidentifier) returns nvarchar(100) with execute as caller
as
begin
    declare @NAME nvarchar(100)

    select 
        @NAME = coalesce(DISPLAYNAME,'')
    from 
        dbo.SMARTFIELDCATALOG
    where 
        SMARTFIELDCATALOG.ID = @ID;

    return @NAME
end