TR_SMARTFIELDCATEGORYCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_SMARTFIELDCATEGORYCODE_INSERT_BBNCCODETABLEIDMAP on dbo.SMARTFIELDCATEGORYCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '7e1e7e69-4258-4833-b8e5-01dee479b0a1', ID from inserted end