TR_APPLICATIONRULES_ONLYONEROW

                    CREATE trigger TR_APPLICATIONRULES_ONLYONEROW 
                        on dbo.APPLICATIONRULES
                        after insert 
                        not for replication
                    as begin
                        set nocount on;
                        begin try
                            if ((select count(ID) from dbo.APPLICATIONRULES) > 1)
                                RAISERROR('ERR_ONLYONEAPPLICATIONRULESROW', 16, 1);

                            if exists(
                                select I.ID
                                from INSERTED I
                                where ACCOUNTINGMETHODCODE = 0 and PAYMENT = 1                    
                              )
                              begin
                                raiserror('CK_APPLICATIONRULES_PAYMENT_VALID', 13, 1);
                              end

                            if exists(
                                select I.ID
                                from INSERTED I
                                where ACCOUNTINGMETHODCODE = 0 and CREDIT = 1                    
                              )
                              begin
                                raiserror('CK_APPLICATIONRULES_CREDIT_VALID', 13, 1);
                              end

                             if exists(
                                select I.ID
                                from INSERTED I
                                where ACCOUNTINGMETHODCODE = 0 and CHARGE = 1                    
                              )
                              begin
                                raiserror('CK_APPLICATIONRULES_CHARGE_VALID', 13, 1);
                              end
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                        end catch
                    end