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编辑  收藏  举报

导航