UFN_GIFTFEEPAYMENTMETHOD_UNIQUE
Validates that values are unique for the gift fee payment method table.
Return
Return Type |
---|
bit |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@PAYMENTMETHODCODE | tinyint | IN |
Definition
Copy
create function dbo.UFN_GIFTFEEPAYMENTMETHOD_UNIQUE (@PAYMENTMETHODCODE tinyint)
returns bit
with execute as caller
as
begin
declare @r as int;
select @r = count(*) from dbo.GIFTFEEPAYMENTMETHOD where PAYMENTMETHODCODE = @PAYMENTMETHODCODE;
if @r <= 1 --No others
return 1
return 0
end