TR_RESEARCHGROUPCATEGORYCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_RESEARCHGROUPCATEGORYCODE_INSERT_BBNCCODETABLEIDMAP on dbo.RESEARCHGROUPCATEGORYCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'e3328f8c-f6d7-44c0-90dc-1bec4df4a46d', ID from inserted end