UFN_FINANCIALINSTITUTION_GETBRANCHNAME

Return

Return Type
nvarchar(100)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


create function dbo.[UFN_FINANCIALINSTITUTION_GETBRANCHNAME]
(
  @ID uniqueidentifier
)
returns nvarchar(100)
with execute as caller
as
begin
  declare @BRANCHNAME nvarchar(100);

  select 
    @BRANCHNAME = [BRANCHNAME]
  from dbo.[FINANCIALINSTITUTION]
  where [ID] = @ID;

  return @BRANCHNAME;
end