TR_PROSPECTRESEARCHREQUESTPRIORITYCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_PROSPECTRESEARCHREQUESTPRIORITYCODE_INSERT_BBNCCODETABLEIDMAP on dbo.PROSPECTRESEARCHREQUESTPRIORITYCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'a76b51de-e242-4ce9-8e88-46e4cd20f5af', ID from inserted end