JSON Support coming to SQL Server
One useful feature coming to SQL Server 2016 is the support for JSON. This makes sense since WebAPI is becoming popular and the default supported format is JSON. The syntax is pretty much like the XML support inside SQL Server. For example: Select ... From ... For JSON PATH, Root('Orders') Or FOR JSON AUTO Read more: http://blogs.msdn.com/b/sqlserverstorageengine/archive/2015/06/07/for-json-clause-in-sql-server-2016-ctp2.aspx