CREATE trigger TR_APPLICATIONRULES_ONLYONEROW
on dbo.APPLICATIONRULES
after insert
not for replication
as begin
set nocount on;
begin try
if ((select count(ID) from dbo.APPLICATIONRULES) > 1)
RAISERROR('ERR_ONLYONEAPPLICATIONRULESROW', 16, 1);
if exists(
select I.ID
from INSERTED I
where ACCOUNTINGMETHODCODE = 0 and PAYMENT = 1
)
begin
raiserror('CK_APPLICATIONRULES_PAYMENT_VALID', 13, 1);
end
if exists(
select I.ID
from INSERTED I
where ACCOUNTINGMETHODCODE = 0 and CREDIT = 1
)
begin
raiserror('CK_APPLICATIONRULES_CREDIT_VALID', 13, 1);
end
if exists(
select I.ID
from INSERTED I
where ACCOUNTINGMETHODCODE = 0 and CHARGE = 1
)
begin
raiserror('CK_APPLICATIONRULES_CHARGE_VALID', 13, 1);
end
end try
begin catch
exec dbo.USP_RAISE_ERROR;
end catch
end
|
Trigger Definition
