UFN_BANKACCOUNT_GETROUTINGNUMBER

This function gets the routing number for the bank account from the bank if it exists.

Return

Return Type
nvarchar(9)

Parameters

Parameter	Parameter Type	Mode	Description
@BANKID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BANKACCOUNT_GETROUTINGNUMBER(@BANKID uniqueidentifier)
            returns nvarchar(9)
            with execute as caller
            as begin
                declare @ROUTINGNUMBER nvarchar(9);

                select @ROUTINGNUMBER = 
                    BANK.DEFAULTROUTINGNUMBER from dbo.BANK where BANK.ID = @BANKID

                return @ROUTINGNUMBER
            end