JsonFileToSQL.sql

/*
source: https://www.sqlshack.com/import-json-data-into-sql-server/

sample json
[
    {
        "id": "1",
        "name": "paco"
    },
    {
        "id": "2",
        "name": "jose"
    },
    {
        "id": "3",
        "name": "manolo"
    }
]
*/

DECLARE @JSON NVARCHAR(max)
SELECT @JSON=BulkColumn
FROM OPENROWSET (BULK 'D:\CODE\jsonlist.json', SINGLE_CLOB) import
SELECT * INTO  JSONTable
FROM OPENJSON (@JSON)
WITH
(
  id NVARCHAR(5),
  name NVARCHAR(50)
)

SELECT * FROM JSONTable