TR_ALTERNATELOOKUPIDTYPECODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_ALTERNATELOOKUPIDTYPECODE_INSERT_BBNCCODETABLEIDMAP on dbo.ALTERNATELOOKUPIDTYPECODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '2c97fd65-6e9c-4508-8d4f-69bdcca010dc', ID from inserted end