JSON in SQL Server prior to SQL Server 2016
JSON has established itself as a respectable and important data exchange format in the last 5-6 years. You read that JSON support in SQL Server was requested 5 years ago. Since this support was not provided prior to SQL Server 2016, developers had to implement their own solutions. They had to use either CLR or Transact-SQL to process and manipulate JSON data in SQL Server. This section will briefly mention a few solutions.
JSON4SQL
JSON4SQL is a commercial CLR-based solution (with a trial version). It provides a fast, feature-rich binary JSON type for SQL Server. JSON4SQL stores JSON in a binary format ported from the JSONB format used in the PostgreSQL database. It is available at the following web address: ...
Get SQL Server 2016 Developer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
