SQL Server 2016’s JSON Integration
Innovations of the 2010s (SQL Server 2012 – 2019)SQL Server 2016’s JSON IntegrationSQL Server 2016’s JSON Integration
Before SQL Server 2016, you had to roll your own support for JSON if you wanted to incorporate it with SQL Server. SQL Server 2016 added integrated JSON support, with the ability to format and export data as JSON; load JSON text in tables; extract values from JSON text; and index properties in JSON text.
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.