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