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