Why SQL returns an Array instead of an Object?
You just need the WITHOUT_ARRAY_WRAPPER
option:
SELECT 1 AS One,2 AS Two,3 AS ThreeFOR JSON PATH ,WITHOUT_ARRAY_WRAPPER;
You just need the WITHOUT_ARRAY_WRAPPER
option:
SELECT 1 AS One,2 AS Two,3 AS ThreeFOR JSON PATH ,WITHOUT_ARRAY_WRAPPER;