JSON in SQL, Expanding the Possibilities!


You're going to run into JSON data. And it's getting common enough that it's now hard to push back and request the data get converted to some time of table format; you are expected to hand JSON data now. So let's look at the built-in ways to handle it natively in SQL Server, starting with 2016. There are various ways import and export the data, some special considerations since the data can be nested and denormalized with implicit linking. Luckily, compared to XML data, we have a few additional built in functions that make working with JSON much easier than XML. We won't cover external programs and manual processing of the JSON strings, since SQL Server can natively handle the data.


  • Mike Burek

    13 Recordings

    Mike is the leader of the Austin SQL User Group

Recorded At:

Recorded on:

Nov 15, 2022

More Info:



  • SQL 26 Recordings
  • Json 3 Recordings