OUTFILE Microsoft SQL Server equivalent?

Question

Is there something like INTO...OUTFILE (from MySQL) in Microsoft SQL Server?

What are you trying to achieve (apart from getting some data out of your database and on to disk)? Your question is rather lacking detail, if you explain *why* you want this functionality it might help others answer you question. SQL Server has SSIS (DTS depending on earlier versions) to export data, will that not do what you want? — Tony, Jun 17 '11 at 20:30
I was thinking the same thing here- DTS. Didn't want to provide that answer though because the question left so much without explanation... — Mike Veigel, Jun 17 '11 at 20:31

Brian Webster · Accepted Answer · 2011-06-17T20:37:26.570

4

This code causes the query results to be dumped into a text file.

EXEC master..xp_cmdshell'bcp "SELECT TOP 5 CUSTOMERID FROM Northwind.dbo.Customers" queryout "c:\text.txt" -c -T -x'

References:

edited Jun 17 '11 at 20:37

answered Jun 17 '11 at 20:31

Brian Webster

30,033
48
152
225

I was looking for something like this. I needed to export data from query itself.Thank you :) – Melvin Smiley Jun 17 '11 at 20:36

score 2 · Answer 2 · answered Oct 02 '12 at 17:15

2

You can also use the sqlcmd or osql (in SQL 2000) to store the output from a command line outside of SSMS very like working with mysql from the command line. You just have to provide the correct parameters, including the query you want to run.

answered Oct 02 '12 at 17:15

KMC

31
1
4

score 1 · Answer 3 · edited May 23 '17 at 12:27

1

It depends on how fancy you want to get. You can use SSMS to generate a CSV A less user-friendly option is a BCP export. Which I see @hamlin11 just suggested

edited May 23 '17 at 12:27

Community

1
1

answered Jun 17 '11 at 20:34

billinkc

59,250
9
102
159

OUTFILE Microsoft SQL Server equivalent?

3 Answers3