However, SQL Server 2016 also fully supports the rowset-to-JSON query scenario when you write a regular T-SQL query and then map results to JSON objects via the FOR JSON clause. For more information ...

Twitter used to provide CSV exports of your data, now it's all in machine-readable JSON. How can you use it in Excel?

Returning JSON from SQL Server Queries. With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the ...