sql 使用select 生成json 

SELECT  LEFT(Result, LEN(Result) - 1) FROM ( SELECT ( 
SELECT  TOP 5 '{"organizationTitle":"' + [Name] + '"' ,',"orgainizationGUName":"' + [Name] + '"},'FROM  [Station]
 FOR XML PATH('') ) AS Result ) AS t

 

posted @ 2017-04-20 10:04  simadi  阅读(1147)  评论(0)  编辑  收藏  举报