4 ms·
SQL 2016 does JSON https://blogs.msdn.microsoft.com/jocapc/2015/05/16/json-support-in-sql-server-2016/ https://blogs.msdn.microsoft.com/jocapc/2015/05/16/json-s
by intrasight 11y ago
SQL 2016 does JSON
https://blogs.msdn.microsoft.com/jocapc/2015/05/16/json-support-in-sql-server-2016/ https://blogs.msdn.microsoft.com/jocapc/2015/05/16/json-supp...
- tracker1 11y agoNice to know, they query syntax is, unfortunately only slightly nicer than the XML options... at least at first glance.
- philliphaydon 11y agoI wish people would stop saying this. The JSON support in SQL Server 2016 is far from being comparable to the JSON support in pgsql.
- mmmBacon 11y agoWell actually it "supports" JSON as NVARCHAR. There is no JSON type and no JSONB type that supports indexing like in Postgres.