UFN_GRADEBOOKSPECIALCHARACTER_SHORTDESCISUNIQUE
Make sure that the short description of the special character is unique.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SHORTDESCRIPTION | nvarchar(10) | IN | |
| @FACULTYID | uniqueidentifier | IN | |
| @ISREGISTRARCREATED | bit | IN |
Definition
Copy
CREATE function dbo.UFN_GRADEBOOKSPECIALCHARACTER_SHORTDESCISUNIQUE
(
@SHORTDESCRIPTION nvarchar(10),
@FACULTYID uniqueidentifier,
@ISREGISTRARCREATED bit
)
returns bit
with execute as caller
as begin
declare @COUNT int;
if @ISREGISTRARCREATED = 1
select @COUNT = count(ID)
from dbo.GRADEBOOKSPECIALCHARACTER
where SHORTDESCRIPTION = @SHORTDESCRIPTION
else
select @COUNT = count(ID)
from dbo.GRADEBOOKSPECIALCHARACTER
where (FACULTYID = @FACULTYID or ISREGISTRARCREATED = 1) and SHORTDESCRIPTION = @SHORTDESCRIPTION
if (@COUNT <= 1)
return 1;
return 0;
end