JSON Support in SQL Server 2016

dev comments edit

Recently I needed to export some data from SQL Server into JSON files. I found out that this is now a trivial task with SQL Server 2016 as it has built-in support for JSON.

The easiest way to get results is using the AUTO keyword:

SELECT * FROM Customers
FOR JSON AUTO

Comments