Database

select convert(int, substring(data.field, 1, 1)) * 1,
       convert(int, substring(data.field, 2, 1)) * 2,
       convert(int, substring(data.field, 3, 1)) * 3,
       convert(int, substring(data.field, 4, 1)) * 4,
       convert(int, substring(data.field, 5, 1)) * 5,
       convert(int, substring(data.field, 6, 1)) * 6,
       convert(int, substring(data.field, 7, 1)) * 7,
       convert(int, substring(data.field, 8, 1)) * 8
       ...
from (select convert(varchar(63), 10101010101010)
       + replicate('0', 63-len(convert(varchar(63), 10101010101010))) as field
       ) data

declare @S as nvarchar(63)
set @S = '10101010101010'

declare @NS as nvarchar(128)
set @NS=''
declare @Len as int
SET @Len = LEN(@S)

declare @Counter as int
SET @Counter = 1
WHILE @Counter < = @Len
BEGIN
	if (SUBSTRING(@S,@Counter,1)='1')
		set @NS = @NS + ' ' + convert(nvarchar,@Counter)
	SET @Counter = @Counter + 1
END
select @NS

public void Import_Data(String XMLFILE_Parth)
       {

           con = new SqlConnection(StrconImport); //Your connection declared somewhere in the Class :)

           DataSet ds = new DataSet();    //Your dataset to do the final dumping

           ds.ReadXml(XMLFILE_Parth);     //sending the it to the Dataset

           SqlBulkCopy sbc = new SqlBulkCopy(con); //object of bulkcopy and put in your connection object inside it

           try
           {
               con.Open();  //open the connection

               sbc.DestinationTableName = "dbo.XML_Resources_Import_temp";  //You must have this table on the SQL , match the Columns

               sbc.WriteToServer(ds.Tables[0]); //Send the Data from the Dataset to the table


           }
           catch (SqlException)
           {
               throw;
           }
           finally
           {


               if (con != null)
               {
                   con.Close();
               }
           }

       }

SELECT * 
FROM OPENROWSET(BULK 'path\file', SINGLE_BLOB) AS alias

INSERT INTO targetTable (targetColumn)
SELECT CONVERT(xml, alias.sourcecolumn)
FROM OPENROWSET(BULK 'path\file', SINGLE_BLOB) AS alias