TR_BANKACCOUNTTRANSACTION_EXT_VALIDATION_IU
Definition
Copy
create trigger [dbo].[TR_BANKACCOUNTTRANSACTION_EXT_VALIDATION_IU] on dbo.BANKACCOUNTTRANSACTION_EXT for INSERT, UPDATE not for replication as
begin
set nocount on;
if exists(select BAT.ID from dbo.BANKACCOUNTTRANSACTION BAT
inner join INSERTED I
on I.BANKACCOUNTID = BAT.BANKACCOUNTID
and I.TRANSACTIONTYPECODE = BAT.TRANSACTIONTYPECODE
and I.TRANSACTIONNUMBER = BAT.TRANSACTIONNUMBER
and I.ID != BAT.ID
where BAT.DELETED = 0)
begin
raiserror('UIX_BANKACCOUNTTRANSACTION_BANKACCOUNTID_TRANSACTIONTYPECODE_TRANSACTIONNUMBER', 16, 1);
rollback transaction;
end;
end;