TR_NAMINGOPPLOCATIONSTATUSCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_NAMINGOPPLOCATIONSTATUSCODE_INSERT_BBNCCODETABLEIDMAP on dbo.NAMINGOPPLOCATIONSTATUSCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'a9b1aa24-26c5-49d8-ab4e-94b091c85e98', ID from inserted end