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