TR_NAMINGOPPORTUNITYFACILITYCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_NAMINGOPPORTUNITYFACILITYCODE_INSERT_BBNCCODETABLEIDMAP on dbo.NAMINGOPPORTUNITYFACILITYCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '3f4565cc-5245-41d1-98e6-7786ac73ffa3', ID from inserted end