UFN_GRADEBOOKSPECIALCHARACTER_NAMEISUNIQUE
Make sure that the name of the special character is unique.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @NAME | nvarchar(60) | IN | |
| @FACULTYID | uniqueidentifier | IN | |
| @ISREGISTRARCREATED | bit | IN |
Definition
Copy
CREATE function dbo.UFN_GRADEBOOKSPECIALCHARACTER_NAMEISUNIQUE
(
@NAME nvarchar(60),
@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 NAME = @NAME
else
select @COUNT = count(ID)
from dbo.GRADEBOOKSPECIALCHARACTER
where (FACULTYID = @FACULTYID or ISREGISTRARCREATED = 1) and NAME = @NAME
if (@COUNT <= 1)
return 1;
return 0;
end