XML and JSON Recipes for SQL Server

Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up the problem that you want to solve, read the solution, and apply it directly in your own code. Problem solved! This book shows how to take advantage of XML and JSON to share data and automate tasks. JSON is commonly used to move data back and forth between the database and front-end applications, often running in a browser. This book covers everything you need to know about transforming query results into JSON format and back again. It also discusses the processes and techniques for moving data into and out of XML format for business intelligence and other purposes, such as transferring data from a reporting system into a data warehouse or between different database brands.