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