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