TR_DONORCHALLENGEMEDIALINKTYPECODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_DONORCHALLENGEMEDIALINKTYPECODE_INSERT_BBNCCODETABLEIDMAP on dbo.DONORCHALLENGEMEDIALINKTYPECODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'c2cf524e-76e6-4caa-9223-58b8bc7e45a1', ID from inserted end