sql for xml path
SELECT '{"data":[' +
STUFF((
SELECT TOP 5 ',{"id":"' + CAST(Id AS VARCHAR) + '","value":"' + EnterpriseId + '"}'
FROM dbo.EntryConfigs
FOR XML PATH('')),1,1,'')
+ ']}' ;
{
"data": [{
"id": "1",
"value": "7460173e-a8cd-4ca8-9959-fe3e70fca0ef"
}, {
"id": "2",
"value": "00000000-0000-0000-0000-000000000000"
}, {
"id": "3",
"value": "803da4d5-4125-4068-b3a2-4678ee32e33d"
}, {
"id": "4",
"value": "9B0287C5-8E79-47E2-B6FC-8FD31053A9AB"
}, {
"id": "5",
"value": "8fd56e43-2a41-40e5-9e33-c7e56f5d4e2b"
}]
}
posted on 2019-12-31 17:06 Aidou_dream 阅读(117) 评论(0) 收藏 举报
浙公网安备 33010602011771号