UFN_BANK_ROUTINGUNIQUE
This function checks to make sure the routing number does not already exist on a bank or bank account.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BANKID | uniqueidentifier | IN | |
| @ROUTINGNUMBER | nvarchar(9) | IN |
Definition
Copy
CREATE function dbo.UFN_BANK_ROUTINGUNIQUE
(
@BANKID uniqueidentifier,
@ROUTINGNUMBER nvarchar(9)
)
returns bit
with execute as caller
as begin
if exists(
select
DEFAULTROUTINGNUMBER
from
dbo.BANK
where
BANK.ID <> @BANKID AND
BANK.DEFAULTROUTINGNUMBER = @ROUTINGNUMBER
AND @ROUTINGNUMBER <> ''
)
or
exists(
select
ROUTINGNUMBER
from
dbo.BANKACCOUNT
where
BANKACCOUNT.BANKID <> @BANKID AND
BANKACCOUNT.ROUTINGNUMBER = @ROUTINGNUMBER AND
@ROUTINGNUMBER <> ''
)
return 1;
return 0;
end