为什么SQL返回数组而不是对象? [英] Why SQL returns an Array instead of an Object?

问题描述

我正在使用SQL SERVER 2016 JSON结果，但是我不知道为什么它将所有内容都转换为数组，例如如果我执行以下查询，它将返回一个数组而不是一个对象:

I'm using SQL SERVER 2016 JSON result, but I don't know why it converts everything to array, e.g. if I execute the following query it returns an array instead of an object:

SELECT 1 AS One,2 AS Two,3 AS Three
FOR JSON PATH

结果是:

[{"One":1,"Two":2,"Three":3}]

但是我希望它返回:

{"One":1,"Two":2,"Three":3}

我也测试了这个查询，但是结果是一样的，再次是一个数组:

Also I tested this query, but the result was the same, again an array:

SELECT TOP 1 1 AS One,2 AS Two,3 AS Three
FOR JSON PATH

推荐答案

您只需要WITHOUT_ARRAY_WRAPPER选项:

SELECT 1 AS One,2 AS Two,3 AS Three
FOR JSON PATH ,WITHOUT_ARRAY_WRAPPER; 

这篇关于为什么SQL返回数组而不是对象?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！