Well with SQL Server 2016 you can export SQL table rows into JSON string format. JSON in SQL will just work like XML with similar semantics.

Check this: Export SQL table to JSON string[/url]

MSDN BoL on JSON & SQL: https://msdn.microsoft.com/en-us/library/dn921882(v=sql.130).aspx