T-SQL – JSON Cheatsheet

I’ve recently been doing a lot of JSON stuff in T-SQL. I figured it would benefit me to create a cheatsheet of some of the coding I’ve been doing. Hopefully they help you in some way!

A few quick links for more info:

• JSON Intro Homepage
• JSON T-SQL Functions

Converting Single Object

In the code below, you’ll find how to format a single object from a result set to JSON and back:

Converting Array Object

In the code below, you’ll find how to format an array from a result set to JSON and back:

Happy coding!