UFN_STATE_GETDESCRIPTION

Return

Return Type
nvarchar(100)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_STATE_GETDESCRIPTION(@ID uniqueidentifier) returns nvarchar(100) with execute as caller
AS
BEGIN
    declare @DESCRIPTION nvarchar(100)

    select @DESCRIPTION = DESCRIPTION from dbo.STATE where ID = @ID

    RETURN @DESCRIPTION
END