UFN_SIMPLEDATALIST_EXISTS

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



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

                return 0;
            end