TR_CHARGEDEFAULTS_ONLYONEROW

Definition

Copy


                    CREATE trigger TR_CHARGEDEFAULTS_ONLYONEROW 
                        on dbo.CHARGEDEFAULTS
                        after insert 
                        not for replication
                    as begin
                        if ((select count(ID) from dbo.CHARGEDEFAULTS) > 1)
                            RAISERROR('ONLYONECHARGEDEFAUTLSROW', 16, 1);
                    end