3 ms·
MS SQL does support XML types / allow you to use XPath in your queries. To my knowledge it doesn't do JSON; but its easy to convert between the two. http://b
by johnlbevan2 11y ago
MS SQL does support XML types / allow you to use XPath in your queries.
To my knowledge it doesn't do JSON; but its easy to convert between the two.
http://blog.sqlauthority.com/2012/04/27/sql-server-introduction-to-discovering-xml-data-type-methods-a-primer/ http://blog.sqlauthority.com/2012/04/27/sql-server-introduct...
- sqldba 11y ago2016 supports JSON.
- philliphaydon 11y agoIt has terrible support.
- intrasight 11y agoSQL 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.
- jimmcslim 11y agoAs the two other comments note, SQL Server 2016 will support JSON, however the extent of the support is significantly less compared to Postgresql. This is unfortunate as I'd love to have better document-db style functionality in SQL Server.