How to Export query result to csv or Tab Delimited File from SSMS - SQL Server/TSQL Tutorial Part 23
How to Export query result to csv or Tab Delimited File from SSMS - SQL Server / T-SQL Tutorial
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..
Step 2:
Provide the file name as you like and type csv or tab.
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.
Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)
http://www.techbrothersit.com/