UFN_SCREENPLAN_GETDESCRIPTION

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_SCREENPLAN_GETDESCRIPTION(@ID uniqueidentifier) returns nvarchar(100) with execute as caller
            as
            begin
                declare @NAME nvarchar(100)
                select @NAME = NAME from dbo.SCREENPLAN where ID = @ID
                return @NAME
            end