Sqlserver 查询结果转Json 

SELECT  * FROM (
SELECT 1 AS ID , 'C#' AS Name
union
SELECT 2 AS ID , 'Java' AS Name
union 
SELECT 3 AS ID , 'JavaScript' AS Name
) TEMP for json auto,root('DataSource')

 

posted @ 2022-08-26 16:06  o天风o  阅读(226)  评论(0)  编辑  收藏  举报