TR_CONSTITUENTBUSINESSRULESSETTINGS_ENSUREONEROW_INSERT
Definition
Copy
create trigger dbo.TR_CONSTITUENTBUSINESSRULESSETTINGS_ENSUREONEROW_INSERT
on dbo.CONSTITUENTBUSINESSRULESSETTINGS
after insert
as
begin
set nocount on;
if (select count(*) from dbo.CONSTITUENTBUSINESSRULESSETTINGS) > 1
begin
exec dbo.USP_RAISE_ERROR;
rollback transaction;
end
end