I have this simple SELECT statement but am struggling to output it to a file using SQL Server 2005:
--QUOTER QUOTE DETAILS SELECT dbo.quoteproduct.quoteid, dbo.quoteproduct.productgroupid, dbo.product.productname, dbo.product.description, dbo.quoteproduct.price FROM dbo.quoteproduct, dbo.product WHERE dbo.quoteproduct.productid = dbo.product.productid;
In other versions of SQL like Sybase I can use the command OUTPUT TO as below but this doesnt work:
OUTPUT TO 'D:\QuoterQuoteDetails.txt' FORMAT ascii DELIMITED BY '|' QUOTE '';
After bing'ing it I have found that you can call an xp_cmdshell to output query results but this only seems to store data in a temporary table not a file.
Id appreciate any help on this.
You want BCP, something like:
Should do the trick.
answered Nov 16 '09 at 12:40 PM
You can also right-click the query window: "Query Options | results | text" formatting options, then (right-click) query window and change "results to" to file.
This is a quick, one-time way redirect the output to a file.
answered Nov 16 '09 at 01:18 PM