November 23rd, 2003, 11:09 PM
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.
November 25th, 2003, 12:58 PM
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.