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 阅读(113) 评论(0) 编辑 收藏 举报