UFN_FAFVALIDTYPEGUID
Validate Typeguid for tracking
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TYPEGUID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_FAFVALIDTYPEGUID(@TYPEGUID uniqueidentifier)
returns bit
with execute as caller
as begin
IF EXISTS (SELECT 1 FROM dbo.REGISTRANT (NOLOCK) WHERE ID = @TYPEGUID)
BEGIN
return 1
END
IF EXISTS (SELECT 1 FROM dbo.REVENUE (NOLOCK) WHERE ID = @TYPEGUID)
BEGIN
return 1
END
return 0
end