TR_SURVEYCATEGORYCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_SURVEYCATEGORYCODE_INSERT_BBNCCODETABLEIDMAP on dbo.SURVEYCATEGORYCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '96506732-244b-48b7-9f49-73cd0a673755', ID from inserted end