UFN_DATALIST_EXISTS

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy



create function dbo.UFN_DATALIST_EXISTS (@ID as uniqueidentifier)
returns bit
with execute as caller
as
begin
    if exists(select ID from dbo.DATALISTCATALOG where DATALISTCATALOG.ID = @ID)
        return 1;

    return 0;
end