How to Export query result to .csv or Tab Delimited File in SQL Server Management Studio(SSMS) - SQL Server / TSQL Tutorial Part 23

Scenario:

I can view query results in SQL Server Management Studio(SSMS), Is there a way to save the query results to csv file or tab delimited file from SSMS?


Solution:

We often need to save the query results to csv or tab delimited format. SQL Server Management does let us save the results to csv and tab delimited format.

Step 1:
Run your query and go to Grid and right click any where in the grid and then choose Save Results As..
How to save query results to csv file or tab delimited format from SSMS - SQL Server Tutorial


Step 2:
Provide the file name as you like and type csv or tab as shown below.
Export query result to .csv file in SQL Server Management Studio - SQL Server / TSQL Tutorial

The results will be exports to file. You can open the file with excel or you can open with notepad. Here I opened with notepad.


How to export query results to csv or tab delimited file from SSMS - SQL Server Tutorial


1 comment:

  1. Managing a business in general and various workflows in particular can be time-consuming if you don't use up-to-day systems. And it's cool that now you can quickly find a high-quality financial management system, for example, to deal with finances in a company and systematize this process. This is a necessary software now, in my opinion.

    ReplyDelete