mssql table import from json file 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: sql server import json

If (ISJSON(@JSON)=1)
SELECT @JSON AS 'JSON Text'