undefined | Better HN

0 pointsjohnlbevan210y ago0 comments

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.

0 comments

I wish people would stop saying this. The JSON support in SQL Server 2016 is far from being comparable to the JSON support in pgsql.

Well actually it "supports" JSON as NVARCHAR. There is no JSON type and no JSONB type that supports indexing like in Postgres.

Nice to know, they query syntax is, unfortunately only slightly nicer than the XML options... at least at first glance.

As 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.

sqldba10y ago

2016 supports JSON.

It has terrible support.

j / k navigate · click thread line to collapse