json parsing

Hello guys, sometimes while working with sql server, we sometimes face the need of working with json data . For that purpose we have to be able to read json data in sql which is quite a difficult task, so we will see how to read json in sql server in simple steps.