TR_COURSENOTETYPECODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_COURSENOTETYPECODE_INSERT_BBNCCODETABLEIDMAP on dbo.COURSENOTETYPECODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '1e1bf668-a526-4056-8b40-55619bb52270', ID from inserted end