Follow these steps for exercises for JSON T-SQL enhancements and new functions for SQL Server 2022.
- SQL Server 2022 Evaluation or Developer Edition
- VM or computer with 2 CPUs and at least 8Gb RAM.
- SQL Server Management Studio (SSMS). The latest 18.x build or 19.x build will work.
- Execute all the statements in the script json_array.sql to see how JSON_ARRAY() and ISJSON() functions work.
- Execute all the statements in the script json_object.sql to see how JSON_OBJECT and JSON_PATH_EXISTS() work.