UFN_BANKACCOUNT_GETACCOUNTDESCRIPTION

Return

Return Type
nvarchar(100)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


                create function dbo.UFN_BANKACCOUNT_GETACCOUNTDESCRIPTION
                (
                  @ID uniqueidentifier
                ) returns nvarchar(100
                as
                begin
                    declare @ACCOUNTDESCRIPTION nvarchar(100);

                    select @ACCOUNTDESCRIPTION = DESCRIPTION
                  from dbo.BANKACCOUNT
                  where ID = @ID;

                    return @ACCOUNTDESCRIPTION;
                end