Producing JSON Documents from SQL Server queries via TSQL
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Thu, 22 May 2014 06:00:00 UT
Indexed on
2014/05/28
21:50 UTC
Read the original article
Hit count: 129
Although SQL Server supports XML well, XML's little cousin JSON gets no love. This is frustrating now that JSON is in so much demand. Maybe, Phil Factor suggests, it is possible to leverage all that XML, and XPath, goodness in SQL Server to produce JSON in a versatile way from SQL Queries? Yes, it so happens that there are plenty of alternatives.
FREE eBook – "45 Database Performance Tips for Developers" Improve your database performance with 45 tips from SQL Server MVPs and industry experts. Get the eBook here. |
© SQL Server Central or respective owner