sql-server 低版本 结果转 json
declare @t table(id int, name nvarchar(max), active bit) insert @t values (1, 'Bob Jones', 1), (2, 'John Smith', 0) select '[' + STUFF(( select ',{"id":' + cast(id as varchar(max)) + ',"name":"' + name + '"' + ',"active":' + c.
转载
2022-04-22 17:18:21 ·
367 阅读 ·
0 评论