;WITH CTE AS(
SELECT CAST(ROW_NUMBER()OVER(ORDER BY GETDATE())AS VARCHAR(10))RN
,*
FROM TB
)
SELECT REPLACE(STUFF((SELECT '|{k:'+RN+',v:"'+admin_qx+'"}'
FROM CTE
FOR XML PATH('')),1,1,''),'&','&')SQL2005+
SELECT CAST(ROW_NUMBER()OVER(ORDER BY GETDATE())AS VARCHAR(10))RN
,*
FROM TB
)
SELECT REPLACE(STUFF((SELECT '|{k:'+RN+',v:"'+admin_qx+'"}'
FROM CTE
FOR XML PATH('')),1,1,''),'&','&')SQL2005+
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货