Hi TAUSEEF,
In addition to the answer of deepankarbhatnagar,
Please try with below query. In the inner query, column name should be there for the column value 10.
select * into t from
(SELECT 10 as Col1, xCol
FROM (SELECT *
FROM OPENROWSET (BULK 'C:\Users\TAUSEEF\Desktop\test.xml', SINGLE_CLOB)
AS xCol) AS R(xCol)) a
Please let me know if you have any concern or query on this or if you are facing any other issue.
Thanks