load json into sql server code example

Example 1: sql server import json

SELECT *
FROM OPENJSON (@JSON, '$.data.assets.parcels') 
WITH (id VARCHAR(7), 
		x INT,
		y INT,
		price INT '$.auction_price') -- new column name
)

Example 2: json in sql server

SELECT name, surname  
FROM emp  
FOR JSON AUTO;