TR_OPPORTUNITYDESIGNATIONFMCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_OPPORTUNITYDESIGNATIONFMCODE_INSERT_BBNCCODETABLEIDMAP on dbo.OPPORTUNITYDESIGNATIONFMCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '4124163f-9667-4a45-bb9f-62c0643f2d3c', ID from inserted end