TR_COUNTRY_INSERT_BBNCCODETABLEIDMAP (Trigger)

                
CREATE trigger TR_COUNTRY_INSERT_BBNCCODETABLEIDMAP on dbo.COUNTRY after insert not for replication
as begin
    insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) 
        select '6DCD65EA-4D60-4C43-BA04-63DFC0087212', ID from inserted
end