Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Sep 15, 1999

Using SQL Server Query Analyzer to Export Query

Question:
How do I use SQL Server Query Analyzer to export a query to a text file? I need it pipe-delimited. I think if you can show me how to export it, I can format it using the commands from SQL mail.

I've seen a lot of other people asking this question. If you can answer it, I'll post it giving you credit. (I've looked every place I can think of.)

Answer:
I'm really confused by your question. What is it that you want to export to a text file exactly: the query statement or the query results?

If you need to delimit the result with the pipe character, can you include that in your query? (chr(172), I think.) On the other hand, if you are exporting the data, why not just DTS it out?

The part about SQL mail also throws me, so I'm afraid I don't get the sense of your question.

Try me on e-mail and I'll see if I can help you.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date