Thread: data dump

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    25
    Rep Power
    0

    data dump


    Hi,

    I would like to know how to dump data from MsSQL tables where all the fields are separated by a comer or something.

    I dont have access to the mssql server. I will have to tell the person who does have access to excute the command. So a detailed description would be nice.


    Thanks
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    United States
    Posts
    14
    Rep Power
    0
    what is the interface they're using to access the DB? Query Analyzer? If so, they can simply choose to have the result output to file, instead of the grid. There are opitons for delimiter but default (I believe) is comma. Then just run the T-SQL and they'll be prompted with a save-as dialog. Also, before you run the query, run SET NOCOUNT ON, so the "n row(s) returned" statement isn't tagged to the end of the file.

IMN logo majestic logo threadwatch logo seochat tools logo