INSERT INTO YourTable (JSONColumn) SELECT * FROM OPENROWSET (BULK 'C:\YourJSONFile.json', SINGLE_CLOB) AS json