SQL Server 2016 CTP2 is planned to include the ability to format and export data as JSON string, while SQL server 2016 CTP3 is expected to incorporate the ability to load JSON text in tables, extract ...

Finally, there is a FOR JSON clause that can format any result set returned by SQL query as JSON text: SELECT object_id, name FROM sys.tables FOR JSON PATH Check out the other posts in this four-part ...