SqlServer查询结果直接返回Json
普通查询结果:

Json格式:

Sql语句:
select top 10 * from [dbo].[HR_Department] FOR JSON AUTO, INCLUDE_NULL_VALUES,WITHOUT_ARRAY_WRAPPER
普通查询结果:

Json格式:

Sql语句:
select top 10 * from [dbo].[HR_Department] FOR JSON AUTO, INCLUDE_NULL_VALUES,WITHOUT_ARRAY_WRAPPER