JSON Support in SQL Server 2016
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