JSON functions in SQL Server enable you to combine NoSQL and relational concepts in the same database. Now you can combine classic relational columns with columns that contain documents formatted as JSON text in the same table, parse and import JSON documents in relational structures, or format relational data to JSON text.. GeoPITS brings you the comprehensive details of JSON's support in different versions & editions of SQL Server.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | Yes | Yes | Yes | Yes |
| Version v2017 | Yes | Yes | Yes | Yes | Yes |
| Version v2016 | Yes | Yes | Yes | Yes | Yes |
| Version v2014 | |||||
| Version v2012 |
JSON functions in SQL Server enable you to combine NoSQL and relational concepts in the same database. Now you can combine classic relational columns with columns that contain documents formatted as JSON text in the same table, parse and import JSON documents in relational structures, or format relational data to JSON text.
You can find more details about this version here
Back to all features