How to save sql query results to .csv file

How many rows can excel handle? How do I export SQL data to text file? EXEC master. You can use the Surface Area Configuration Tool. Expand Databases. On the Back Up Database window, make sure the Database field contains the name of the database you want to back up. Select the Backup Type. Now run a query. You will be prompted to save the file instead of the results being shown in the bottom pane. You may have the option to save it as a. This is fine if you can open it in Crystal Reports or a similar application.

If not, you can change the extension to. The third option is -s followed by a comma in quotation marks. This specifies the comma as the separator between the columns in the CSV file. The fourth option is -o to specify the path and the name of the output file. Enclose the path and the file name in quotation marks. And the last option is -E. This indicates that it is a trusted connection to the database server. Using the BCP tool is similar to the previous method.

You can use this tool in the terminal of your operating system. The first word is bcp , followed by the names of the database, the schema, and the table, separated by the period. Then, the command out specifies the path to the result file. Next is the option -S , followed by the name of the server, a backslash, the name of the SQL Server instance, a comma, and the port number for the connection. The option -t in lowercase defines the separator enclosed in quotation marks.

Here, the separator is the comma. When you run this, you see something like the below to let you know the status of copying your data:. In this article, you have learned what a CSV file is, how this format is built, and why it is used in applications or platforms. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more.

How to automatically save sql query results to. Asked 5 years ago. Active 5 years ago. Viewed 34k times. For example I would like to try and do this with part of my query: Select top 1 a. NAME From dbo. Ciaran Donoghue. Ciaran Donoghue Ciaran Donoghue 2 2 gold badges 17 17 silver badges 46 46 bronze badges.