Cacher is the code snippet organizer for pro developers

SELECT JSON_VALUE(x.[Value], '$.Key') as AdditionalInfoName, JSON_VALUE(x.[Value], '$.Value') as AdditionalInfoValue
FROM OPENJSON((select AdditionalInfoJson from dbo.AppControlNumbers where AdditionalInfoJson is not null and Id=445), '$') AS x;