TR_PROSPECTPLANSTATUSCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_PROSPECTPLANSTATUSCODE_INSERT_BBNCCODETABLEIDMAP on dbo.PROSPECTPLANSTATUSCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'f01c8f72-8a9d-471e-98f2-eba57292855b', ID from inserted end