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

Filed under:

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.

sqlprompt 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