Output sql server query to file

It is a very fast option. Use it if you have millions of rows and you need to use the command line or if it is easy to call the command line from your program or script. The following example uses bcp to export the query results to a file named bcp. There are many other ways to export results. However, these options will inspire you to use other ones. SSMS destination to file option - This is the easiest option.

Used if you do not need to automate anything and you just one a txt report immediately. PowerShell - Use it when you are automating tasks with PowerShell or when you are using tools to call PowerShell scripts.

It is a very fast option specialized in exporting and importing data from multiple sources. It is similar to 4, but it can be customized and you can create really complex packages integrated with Web services, send mails, PowerShell and more.

Use it if you need a complex solution that requires integration between multiple tools. C - Use it when you have code for other tasks and you need to integrate with other lines of code in C. Use it when the presentation is important.

BCP - It is a very fast option. Use it for large volumes of data. Log in or register to rate. Join the discussion and add your comment. You have many options when exporting data from a database. In this article, we will show how to do it.

When we administer a SQL Database, we always have to work with files. This new article shows how to handle them using PowerShell. Getting Started Let's look at each of the ways we can export the results of a query. Thx for your reply. This would also dump everything into one file. This would also dump everything to one file. But the size of the xml and the number of the results are to large — AitschPi. Thank for your reply — AitschPi. Steve Steve k 21 21 gold badges silver badges bronze badges.

This does not work in my case. I see your comment above now. I don't know of anything in SSMS that could accomplish your goal. Perhaps using some kind of ad hoc Stored Procedure or using a custom made code in your preferred development environment. Do you know an other tool that could accomplish my goal?

There is a grid-scripting engine, that allows to select scripting granularity to "row". Download, install, play, tell me what you think to support email. Andrei Rantsevich Andrei Rantsevich 2, 18 18 silver badges 23 23 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. You could write a VB app or VB script to run locally and generate a file from your query. There isn't a direct method. I tend to use BCP. BCP only lets you output from a permanent table, though. Erland Sommarskog. No, you don't want to do that. It's not clear why you want to write to a file, but if you want to log some stuff for debug reasons - write to a table instead.

You are in a database, not in a file system. Ok this is great, the tables I need data outputting from are permanent. Basically it is for creating a log file. The database is huge, but the log only needs to contain the contents of a few tables.

It has to go to a file because I want to be able to save the results of the query to disk or print it out. Can I BCP out from several tables into the same file? Alex wrote: Ok this is great, the tables I need data outputting from are permanent. It's a little involved but you can write a select statement joining several tables. Each time BCP executes, I believe it overwrites the text file. This discussion thread is closed Start new discussion.

NET Framework. In Clause - to query text file. How to load and output a text file in C?