The FOR JSON clause is designed to help SQL Server output JSON formatted results to clients.
Here are a list of links that might help you learn more. Note that many of these are links to other sites and we cannot guarantee they still work. We also should note that some of these, especially Books Online, may change over time.
If you find broken links or think we should have more here, please leave a comment in the discussion for this article.
A few general links.
- JSON Tutorial (W3Schools)
- What is JSON and Why Would I Use It? (StackOverflow)
- How fast is FOR JSON compared to generating JSON in application layer?
SQL Server specific links
- Books Online - FOR JSON
- FOR JSON clause in SQL Server 2016 CTP2
- Getting Started with JSON Support in SQL Server 2016 – Part 1
- Splitting Strings in SQL Server 2016
- Understanding OPENJSON and FOR JSON in Azure and SQL 2016
- SQL Server 2016: built-in JSON Use case scenarios
Continue learning more about SQL Server
View the index of features for the various versions.