TR_PROSPECTSTATUSCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_PROSPECTSTATUSCODE_INSERT_BBNCCODETABLEIDMAP on dbo.PROSPECTSTATUSCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '780c5d2d-f0e0-4100-a900-ad829ad4c8f8', ID from inserted end