In this session, I have explained how to convert JSON to SQL and SQL results to JSON.
We often need to convert SQL Output in SQL to JSON Data. We use OpenJSON built in function in SQL to convert JSON Data in SQL. The OPENJSON function is available only under compatibility level 130 or higher in SQL Server.