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":' + cast(active as varchar(max)) 
      +'}' 

     from @t t1 
     for xml path(''), type 
    ).value('.', 'varchar(max)'), 1, 1, '') + ']'