UFN_BUSINESSPROCESS_IDSETEXISTS
Returns a bit value designating whether or not an id set with a given name already exists.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @IDSETNAME | nvarchar(100) | IN |
Definition
Copy
CREATE function dbo.UFN_BUSINESSPROCESS_IDSETEXISTS(@IDSETNAME nvarchar(100))
returns bit
with execute as caller
as begin
if exists(select ID from dbo.IDSETREGISTER where NAME = @IDSETNAME)
return 1
return 0
end