devxlogo

Using SQL Server Query Analyzer to Export Query

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.

See also  lenso.ai - an AI reverse image search platform
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist