[ACCEPTED]-Using bcp utility to export SQL queries to a text file-bcp

Accepted answer

Score: 17

bcp out exports tables.

To export a query use queryout instead 2 - you'll need to wrap your query in "double 1 quotes"

set @logtext = '"select name, type from master.dbo.spt_values where number=6"' 
--set @logtext = 'master.dbo.spt_values' 
SET @cmd = 'bcp ' + @logtext + ' queryout "c:\spt_values.dat" -U uId -P uPass -c' 
EXEC master..XP_CMDSHELL @cmd

http://msdn.microsoft.com/en-us/library/ms162802.aspx

Source: stackoverflow.com

More Related questions

What will be BCP format for inserting a identity column

Stored Procedures to .sql files

SQL Script to alter ALL Foreign Keys to add ON DELETE CASCADE

IF/ELSE Stored Procedure

Conditional Operator in SQL Where Clause

SQL Server 2005 Get First and Last date for any Month in any Year

Set all the 0 values to NULL

How to remove diagramming support objects from SQL Server?

Performance of COUNT SQL function

How to create sequential number column index on table with data

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.