TR_NAMINGOPPORTUNITYAREACODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_NAMINGOPPORTUNITYAREACODE_INSERT_BBNCCODETABLEIDMAP on dbo.NAMINGOPPORTUNITYAREACODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'a433cc63-86a2-43fb-87de-c88a707e11a2', ID from inserted end