UFN_EVENTLOCATION_HASROOM
Determines if a given event location has an event location room record.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTLOCATIONID | uniqueidentifier | IN | |
| @EVENTLOCATIONROOMID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_EVENTLOCATION_HASROOM
(
@EVENTLOCATIONID uniqueidentifier = null,
@EVENTLOCATIONROOMID uniqueidentifier = null
)
returns bit
with execute as caller
as begin
if exists (
select ID
from dbo.EVENTLOCATIONROOM
where ID = @EVENTLOCATIONROOMID
and EVENTLOCATIONID = @EVENTLOCATIONID
)
return 1;
return 0;
end