TR_PROJECTDEPARTMENTCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_PROJECTDEPARTMENTCODE_INSERT_BBNCCODETABLEIDMAP on dbo.PROJECTDEPARTMENTCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '1365379a-20a2-4fd9-98e6-93c4d19a5dab', ID from inserted end