UFN_BATCHTEMPLATE_EXISTS

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



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

                return 0;
            end