UFN_APPUSER_ISCONSTITUENT
Returns true if the user is linked to a constituent record.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_APPUSER_ISCONSTITUENT (@ID uniqueidentifier)
returns bit
as
begin
declare @constitid uniqueidentifier;
select @constitid = CONSTITUENTID
from dbo.APPUSER
where ID = @ID;
if @constitid is null
return 0;
return 1;
end