TR_DESIGNATIONLEVELCATEGORYCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_DESIGNATIONLEVELCATEGORYCODE_INSERT_BBNCCODETABLEIDMAP on dbo.DESIGNATIONLEVELCATEGORYCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '20204242-ba0f-4788-8a88-b235946ebecf', ID from inserted end