Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 how to export sql result in csv/txt file format

Author  Topic 

ivra
Starting Member

18 Posts

Posted - 2009-03-19 : 05:56:17
Hi,

Can someone let me know how to export the result of sql query into csv or text file format by not using BCP command in command prompt.
The problem in BCP is the header column in not included when I used it. Please help

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2009-03-19 : 06:01:20
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Regards

Senthil.C
----------------------------------------------------------------------------
Server: Msg 3902, Level 16, State 1, Line 1
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
Go to Top of Page
   

- Advertisement -