UFN_MEMBERSHIPCARD_CARDNUMBERCOUNT
Checks if a card number already exists.
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CARDNUMBER | nvarchar(100) | IN |
Definition
Copy
CREATE function dbo.UFN_MEMBERSHIPCARD_CARDNUMBERCOUNT
(
@CARDNUMBER nvarchar(100)
)
returns int as
begin
if len(@CARDNUMBER) = 0
return 0;
return (select count(*) from dbo.MEMBERSHIPCARD where CARDNUMBER = @CARDNUMBER);
end