In this video I will show you how to convert JSON to a table using OPENJSON and from a table to JSON using FOR JSON PATH with t-sql. I will also cover querying specific JSON objects using JSON_VALUE as well as validating JSON using ISJSON.