TR_STUDENTCONSTITUENCYSETTINGS_ONLYONEROW

Definition

Copy


                    create trigger TR_STUDENTCONSTITUENCYSETTINGS_ONLYONEROW 
                        on dbo.STUDENTCONSTITUENCYSETTINGS 
                        after insert 
                        not for replication
                    as begin
                        if ((select count(ID) from dbo.STUDENTCONSTITUENCYSETTINGS) > 1)
                            RAISERROR('ONLYONESTUDENTSETTINGSROW', 16, 1);
                    end