TR_DONORCHALLENGESPONSORCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_DONORCHALLENGESPONSORCODE_INSERT_BBNCCODETABLEIDMAP on dbo.DONORCHALLENGESPONSORCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '4c60a6e3-4b33-4fcd-9335-df6fb120ea9c', ID from inserted end