UFN_REGISTRATIONPACKAGE_VALIDMAINEVENT

Validates that the event is a main event.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@EVENTID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_REGISTRATIONPACKAGE_VALIDMAINEVENT
            (
                @EVENTID uniqueidentifier = null
            )
            returns bit with execute as caller
            as
            begin
                if exists
                (
                    select
                        ID
                    from
                        dbo.EVENT
                    where
                        MAINEVENTID = @EVENTID
                )
                    return 1;

                return 0;
            end