UFN_BANKACCOUNT_GETACCOUNTNAME

Return

Return Type
nvarchar(100)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


                CREATE function dbo.UFN_BANKACCOUNT_GETACCOUNTNAME
                (
                  @ID uniqueidentifier
                ) returns nvarchar(100
                as
                begin
                    declare @ACCOUNTNAME nvarchar(100);

                    select @ACCOUNTNAME = ACCOUNTNAME
                  from dbo.BANKACCOUNT
                  where ID = @ID;

                    return @ACCOUNTNAME;
                end