我的表架构是这样的,
DECLARE @mytable AS TABLE(ID INT, EmpName VARCHAR(10), Age INT);
INSERT INTO @mytable
VALUES
(1, 'a', 1),
(2, 'b', 2),
(3, 'c', 3),
(4, 'd', 4),
(5, 'e', 5),
(6, 'f', 6),
(7, 'g', 7),
(8, 'h', 8),
(9, 'i', 9),
(10, 'j', 10);
最初,我的程序返回的数据为
SELECT ID, EmpName, Age FROM @mytable;
处理完数据后,发送到网页
[{1,"a",1},
{2,"b",2},
{3,"c",3},
{4,"d",4},
{5,"e",5},
{6,"f",6},
{7,"g",7},
{8,"h",8},
{9,"i",9},
{10,"j",10}]
If I use
SELECT ID, EmpName, Age
FROM @mytable
FOR JSON AUTO;
结果会像
[{"ID":1,"EmpName":"a","Age":1},
{"ID":2,"EmpName":"b","Age":2},
{"ID":3,"EmpName":"c","Age":3},
{"ID":4,"EmpName":"d","Age":4},
{"ID":5,"EmpName":"e","Age":5},
{"ID":6,"EmpName":"f","Age":6},
{"ID":7,"EmpName":"g","Age":7},
{"ID":8,"EmpName":"h","Age":8},
{"ID":9,"EmpName":"i","Age":9},
{"ID":10,"EmpName":"j","Age":10}]
所以我需要得到的是相同的响应,但没有列名,因为前端库使用没有键的 JSON 数组。
使用 SQL Server 版本 2012。
我希望我的观点很清楚。谢谢。