UFN_EMAILJOB_RECIPIENT_EXISTS
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EMAILJOBRECIPIENTID | int | IN |
Definition
Copy
create function dbo.UFN_EMAILJOB_RECIPIENT_EXISTS
(
@EMAILJOBRECIPIENTID int
)
returns bit
with execute as caller
as begin
declare @IDVALID bit;
set @IDVALID=0;
if exists (
select top 1 [ID]
from [dbo].[EmailJob_Recipient]
where [ID] = @EMAILJOBRECIPIENTID)
set @IDVALID=1;
return @IDVALID
end