TR_PDACCOUNTSYSTEM_UPD
Definition
Copy
CREATE trigger dbo.TR_PDACCOUNTSYSTEM_UPD on dbo.PDACCOUNTSYSTEM
with execute as owner
for update
as
begin
set nocount on
if update(DEFAULTGLACCOUNTID)
delete PDACCOUNTLOOKUPCACHE
from dbo.PDACCOUNTLOOKUPCACHE inner join inserted on PDACCOUNTLOOKUPCACHE.PDACCOUNTSYSTEMID = inserted.ID
end