Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: order of rows during bulk insert

    I found a method that guarantees the order is retained. No other method I found worked 100%.
    ---------------------------------
    Declare @X xml;
    ---------------------------------
    SELECT @X=Cast('<X>'+Replace([BulkColumn],Char(13)+Char(10),'</X><X>')+'</X>' as XML)
    FROM OPENROWSET (BULK...

Viewing post 1 (of 1 total)