TR_PDCOMPOSITESEGMENTMAPPINGENTRY_IUD
Definition
Copy
CREATE trigger [dbo].[TR_PDCOMPOSITESEGMENTMAPPINGENTRY_IUD] on [dbo].[PDCOMPOSITESEGMENTMAPPINGENTRY]
after insert, update, delete not for replication
as
begin
set nocount on
update dbo.PDCOMPOSITESEGMENTMAPPING set PDCOMPOSITESEGMENTMAPPING.COMPOSITESEGMENTKEY = dbo.UFN_PDCOMPOSITESEGMENTMAPPING_KEY(I.PDCOMPOSITESEGMENTMAPPINGID) from inserted I where PDCOMPOSITESEGMENTMAPPING.ID = I.PDCOMPOSITESEGMENTMAPPINGID
end