TR_RELATEDSTAFFROLECODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_RELATEDSTAFFROLECODE_INSERT_BBNCCODETABLEIDMAP on dbo.RELATEDSTAFFROLECODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'e5fb1a7a-24ea-4a50-9791-5e902f07e24f', ID from inserted end