Public preview: JSON in Azure SQL Database
30. marts 2016
- Read data from JSON text by using JSON_VALUE/JSON_QUERY functions.
- Modify JSON text by using the JSON_MODIFY function.
- Transform JSON text into a relational format by using the OPENJSON function - OPENJSON function requires database COMPATIBILITY_LEVEL = 130!
- Easily query or import JSON data into tables.
- Query relational and JSON data stored in any relational table.