Home Forums SQL Server 2014 Administration - SQL Server 2014 export table RE: export table

  • August 24, 2014 at 9:55 pm

    #1740617

    Eirikur Eiriksson (8/22/2014)

    Nita Reddy (8/18/2014)

    I want to export one table but text contains ',' so can I use double " ? I don't see option when I select delimiter how should I do it.?

    Quick suggestion, use the (close to industry standard) CSV (RFC-4180) format with ["] text qualifiers. Should be no problem at all.

    😎

    Better yet, don't use commas for delimiters. Use TABs instead. The folks on the receiving end of the data will love you for it.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)