TR_JOBCATEGORYCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_JOBCATEGORYCODE_INSERT_BBNCCODETABLEIDMAP on dbo.JOBCATEGORYCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'dba845ef-6aba-40dc-8a81-756c9f0d289a', ID from inserted end