OPENJSON function in Sql Server enables you to open complex JSON structures. In this post we will see how you can open GeoJSON format.
Sql Server 2016 and DocumentDb enable you to query JSON documents. DocumentDb has nice syntax for querying JSON documents – you can find some good examples on DocumentDb site . Sql Server provides built-in functions for accessing JSON fields (JSON_VALUE), fragments (JSON_QUERY) and opening JSON documents (OPENJSON). In this post, I will show you some queries that can be executed in DocumentDb and equivalent Sql Server queries.
In this post we will see how to index JSON text using full text search. Full text search indexes can be applied on any text data, so we can use it to index elements in JSON arrays. In this example I will create index on array of sales reasons.
In this post I will talk about one annoying thing – how to return a result set containing one to many relationships between tables? In that case you will have multiple primary rows because one row is generated per for each child row. in this post we will see how you can resolve this problem using JSON.