JAVASCRIPT

how to parse json in sql server

DECLARE @json NVarChar(2048) = N'{
  "owner": null,
  "brand": "BMW",
  "year": 2020,
   "status": false
}';
 
SELECT * FROM OpenJson(@json);

sql server - Parse JSON string in sql

Since sql server has no JSON support built in, you'd need to parse this manually, which would get complicated.

However, you could always use somebody else's JSON parsing library.