JAVASCRIPT

convert json to table in sql server

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