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: http://www.json4sql.com.
JSON.SQL
JSON.SQL is a CLR-based JSON serializer/deserializer for SQL Server written by Bret Lowery, available at this address: http://www.sqlservercentral.com/articles/SQLCLR/74160/. It uses a popular JSON framework—Json...
