Here is the sql statement:
INSERT INTO BinarizeResults(url, [file],[state],Binarize,Binarize2,FilterGaussian,FilterMedianSmooth,HoughLines,OptimizeImageSize,PreprocessImage,RemovePepperNoise,RemoveSaltNoise,accuracy,Task_Length)
SELECT X.a.query('url'.value('.','VARCHAR(50)')),
X.a.query('file'.value('.','VARCHAR(50)')),
X.a.query('state'.value('.','VARCHAR(20)')),
X.a.query('Binarize'.value('.','VARCHAR(6)')),
X.a.query('Binarize2'.value('.','VARCHAR(6)')),
X.a.query('FilterGaussian'.value('.','VARCHAR(6)')),
X.a.query('FilterMedianSmooth'.value('.','VARCHAR(6)')),
X.a.query('HoughLines'.value('.','VARCHAR(6)')),
X.a.query('OptimizeImageSize'.value('.','VARCHAR(6)')),
X.a.query('PreprocessImage'.value('.','VARCHAR(6)')),
X.a.query('RemovePepperNoise'.value('.','VARCHAR(6)')),
X.a.query('RemoveSaltNoise'.value('.','VARCHAR(6)')),
X.a.query('accuracy'.value('.','VARCHAR(6)')),
X.a.query('Task_Length'.value('.','VARCHAR(10)'))
FROM (
SELECT CAST(x AS XML)
FROM OPENROWSET(
BULK 'C:\Users\Jarmendariz\Desktop\ocrbinarize.xml', SINGLE_BLOB
)
AS T(x)
)
AS T(x)
CROSS APPLY x.nodes('resultset/results/result') AS X(a);