Blog Home  Home Feed your aggregator (RSS 2.0)  
Mayur's Blog - Query JSON and parse the JSON text right into SQL Server 2016 to off-load some processing cost from your managed code layer
 
# Thursday, January 25, 2018

We all know that JSON data can be stored in SQL database as text, however, it was not possible directly to query and parse this JSON text right into database engine. Historically, we all have been using some sort of parsing outside of database; such JSON.Net library using C#.NET.

However, SQL Server 2016 has now introduced native support to parse JSON text. Please read the following Visual Studio Magazine article for further details. I have been looking for this type of support and found this article useful. Therefore, I am sharing this detail and hoping that it may be helpful to someone else.

https://visualstudiomagazine.com/articles/2018/01/17/query-json.aspx

Happy coding!

Thursday, January 25, 2018 6:01:37 PM UTC  #       | 
Copyright © 2020 Mayur Bharodia. All rights reserved.
DasBlog 'Portal' theme by Johnny Hughes.
Pick a theme: