TR_VOLUNTEERMEDICALCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_VOLUNTEERMEDICALCODE_INSERT_BBNCCODETABLEIDMAP on dbo.VOLUNTEERMEDICALCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'd562df2c-ff94-4414-bee5-e90e3b80717b', ID from inserted end