UFN_MKTSEGMENT_EXISTS
Returns whether or not a segment exists in the database.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_MKTSEGMENT_EXISTS
(
@ID uniqueidentifier
)
returns bit
as begin
declare @ret bit;
if exists(select top 1 1 from dbo.[MKTSEGMENT] where [ID] = @ID)
set @ret = 1;
else
set @ret = 0;
return @ret;
end