UFN_DESIGNATION_GETNAMEFROMID

Return

Return Type
nvarchar(512)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_DESIGNATION_GETNAMEFROMID(@ID uniqueidentifier) returns nvarchar(512) WITH EXECUTE as CALLER
            as
            begin
                declare @NAME nvarchar(512)
                select @NAME = [NAME] from dbo.DESIGNATION where ID = @ID
                return @NAME
            end