我需要生成一个包含两个不同对象的JSON数组:
[
{
"command": "setcontext",
"recordtype": "client",
"recordid": 1030
},
{
"command": "gotodq",
"usercode": "react_webuser_debtor_details"
}
]
我可以使用以下命令分别生成这两个对象:
SELECT
'setcontext' AS command, 'client' AS recordtype, 1030 AS recordid
FOR JSON PATH, WITHOUT_ARRAY_WRAPPER
SELECT
'gotodq' AS command, 'react_webuser_debtor_details' AS usercode
FOR JSON PATH, WITHOUT_ARRAY_WRAPPER
但我不知道如何将这两条语句合并为一条来得到array.
显然,我可以将两者连接为附加数组标记的字符串,但我很好奇JSON的"纯"SQL解决方案会是什么样子……