sql中查询内容转JOSN

declare @t table(id int, name nvarchar(max), active bit)
insert @t values (1, 'Bob Jones', 1), (2, 'John Smith', 0)
insert @t values (1, 'Bob Jones', 1), (2, 'John Smith', 0)
 
select '[' + STUFF((
        select 
            ',{"id":' + cast(id as varchar(max))
            + ',"name":"' + name + '"'
            + ',"active":' + cast(active as varchar(max))
            +'}'
 
        from @t t1
        for xml path(''), type
).value('.', 'varchar(max)'), 1, 1, '') + ']'