TR_EDUCATIONALSUBDEPARTMENTCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_EDUCATIONALSUBDEPARTMENTCODE_INSERT_BBNCCODETABLEIDMAP on dbo.EDUCATIONALSUBDEPARTMENTCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'fa1a8abb-de22-4398-af1c-cd53cb6f1b28', ID from inserted end