TR_DESIGNATIONUSECODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_DESIGNATIONUSECODE_INSERT_BBNCCODETABLEIDMAP on dbo.DESIGNATIONUSECODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '11747bde-62f2-499f-84ed-75abfe6d9490', ID from inserted end