TR_ETHNICITYCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_ETHNICITYCODE_INSERT_BBNCCODETABLEIDMAP on dbo.ETHNICITYCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '087e04cc-b6db-46f7-89e4-428a47b7999b', ID from inserted end