UFN_AUCTIONITEMSUBCATEGORY_ISUNIQUETOCATEGORY
Ensures that an auction item subcategory name is unique to an auction item category.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @NAME | nvarchar(100) | IN | |
| @AUCTIONITEMCATEGORYID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_AUCTIONITEMSUBCATEGORY_ISUNIQUETOCATEGORY
(
@NAME nvarchar(100),
@AUCTIONITEMCATEGORYID uniqueidentifier
)
returns bit
as begin
declare @ISUNIQUE bit = 0;
declare @COUNT integer = 0;
select
@COUNT = count(ID)
from
dbo.AUCTIONITEMSUBCATEGORY
where
NAME = @NAME
and
AUCTIONITEMCATEGORYID = @AUCTIONITEMCATEGORYID
if @COUNT <= 1
set @ISUNIQUE = 1;
return @ISUNIQUE
end