sql server import json
snippet in sql

insert json into sql

user795

SELECT *
FROM OPENJSON(@json)
 WITH (id int 'strict $.id',
       firstName nvarchar(50) 'strict $.info.name',
       lastName nvarchar(50) '$.info.surname',
       age int,
       dateOfBirth datetime2)

sql server import json

user1268

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

sql server import json

user8998

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

sql server import json

user1625

DECLARE @JSON VARCHAR(MAX)

SELECT @JSON = BulkColumn
FROM OPENROWSET 
(BULK 'C:\file-location\my-data.json', SINGLE_CLOB) 
AS j

sql server import json

user9695

{
  "ok": true,
  "data": {
    "assets": {
      "parcels": [{ 
        "id": "51,100",
        "x": 51,
        "y": 100,
        "auction_price": 4444,
        "district_id": "77909d00",
        "owner": "Dr Cornwallis",
        "data": { "version": 0 }
        }, 
        //...+ 2499 more objects in the parcels array
      ],
      total: 2500
    },
  },
}

sql server import json

user6913

SELECT ISJSON(@JSON)