How to export table or Query output to a file using BCP [ All Languages » SQL Server »  BCP] Total Hit ( 2929) Rate this article:     Poor     Excellent   Submit Your Question/Comment about this article Rating

To export Query result to a file use following command to your command prompt Click here to copy the following block EXEC master..xp_cmdshell 'bcp "select * from pubs..authors" queryout c:\authors.txt -c -Usa -Pmypassword' To export table to a file use following command to your command prompt Click here to copy the following block EXEC master..xp_cmdshell 'bcp "pubs..authors" out c:\authors.txt -c -Usa -Pmypassword'

Related Article(s)

Get listing of files in a specified directory or a network share. This stored procedure also return some useful information (e.g. date, times, directory, filesize, filename)

Copy text or image into or out of SQL Server

Export data to excel file

How to count the number of lines in an external OS file? Will work for ASCII files only.

How to compare rows in tables without writing a SELECT with all the conditions? Can be used for simple dirty work & of course if you are lazy to type.

File details using NT commands & undocumented SP.

How to check for the existence of a file from SQL Server?

How to get NT Accounts from DOMAIN.

How to get the data, tools & SQL path when there are several instances on the same server?

send NET SEND messages to all the connected SQL Server users in an NT Local Arean Network

T-SQL code to log messages to a text file on the server, from your stored procedures and SQL scripts

How to read remote registry using SQL Server.

Read current sql server error log.

Database Backup Script

Stored procedure to Send SMTP mail from SQL SERVER 2000 (Email Body max 8000 chars)

Submitted By : Nayan Patel  (Member Since : 5/26/2004 12:23:06 PM)
	Job Description : He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.
View all (893) submissions by this author  (Birth Date : 7/14/1981 )