Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

I need help exporting SQL Server data to a tab delimitted file

Posted on 2015-02-24
3
Medium Priority
?
130 Views
Last Modified: 2015-03-29
I experts,
I use a few select queries in SQL Server 2008 R2.  I want to export the query results to a tab delimitted file.  How can I do this?  Thank you very much in advance for your help.

mrotor
0
Comment
Question by:mainrotor
3 Comments
 
LVL 43

Accepted Solution

by:
pcelba earned 800 total points
ID: 40628267
Execute the query in SQL Server Management Studio, then right-click the result grid and select "Save Results As" from the context menu. TAB delimited text is one of the available file formats.
0
 
LVL 16

Assisted Solution

by:Deepak Chauhan
Deepak Chauhan earned 800 total points
ID: 40628452
If records count is very high, you can use Import/ Export Wizard. Just right click on database and click on export data.... , next all steps are self-explanatory.
0
 
LVL 52

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 400 total points
ID: 40633423
Yes, I'm also with the Export data option. Instead of choosing a table you need to provide the query that you want.
TaskMenu.PNG
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question