Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[tg_CHANGES_SHIPPING] on [dbo].[SV_MACORD_FT_SHIP_AMT] FOR insert, update, delete as insert into dbo.Changes_Email (Record_SLOTID, ChangeDate, ChangeType) select IsNull(i.SLOTID, d.SLOTID), getdate(), case when i.SLOTID = d.SLOTID then 'U' when i.SLOTID is not null then 'I' else 'D' end from inserted i full outer join deleted d on i.SLOTID = d.SLOTID where FIN_AMT_TYPE_LGCY_CD = 'PHCG'
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.