How to Query JSON in SQL2016 Part2 -2

[@arugollu]

Thanks a lot for the explanation with a lot of clear examples.

[@nicotristan6119]

Pro tip : you can watch series on Flixzone. I've been using it for watching all kinds of movies lately.

[@marvinnova1553]

@Nico Tristan Yup, have been watching on Flixzone for since november myself =)

[@kuntaldas2843]

in 2019 it is still relevant , learned a lot today

[@ritikeshsawaimul2256]

This cant be used in mysql workbench .......

[@techvalley9395]

Excellent, but you did not use multiple dynamic roots. is it possible roots as column name?

[@safaaal-wajidi4606]

thanks for the tutorial. I got the following error Incorrect syntax near 'json'. I use SQL Server 2012. Do you have any Idea about the reason because I cant find solution on the web. Thanks.

[@SQLJUNKIESHARE]

+safaa al-wajidi Can you you provide the complete query that you used to get this error

[@safaaal-wajidi4606]

+SQL JUNKIESHARE Thanks, I install SQLServer2016, and your method work like a charm. I think this facility is not available in old version s of SQLServer.