DECLARE @JSON VARCHAR(MAX) SELECT @JSON = BulkColumn FROM OPENROWSET (BULK 'C:file-locationmy-data.json', SINGLE_CLOB) AS j