TR_GIFTINKINDAPPRAISALSETTINGS_ENSUREONEROW_DELETE

Definition

Copy


                    create trigger dbo.TR_GIFTINKINDAPPRAISALSETTINGS_ENSUREONEROW_DELETE
                        on dbo.GIFTINKINDAPPRAISALSETTINGS
                        after delete
                    as
                    begin
                        set nocount on;

                        if (select count(*) from dbo.GIFTINKINDAPPRAISALSETTINGS) < 1
                        begin
                            exec dbo.USP_RAISE_ERROR;
                            rollback transaction;
                        end
                    end