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.
| Author |
Topic |
|
yaman
Posting Yak Master
213 Posts |
 Posted - 2009-09-25 : 10:22:16
|
| SIR,I want to export data from table into NOTEPAD.txt file on the drive C:I am using this :- EXEC master..xp_cmdshell'osql -S CSIIND10 yam -U yam -P -q "select accountcode from AMRDB..tbl_leafnodes" -o F:\NewTextDocument.txt'But this query unable to export data into notepad .Is there any other way to export data into notepad .Yaman |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-25 : 13:15:00
|
| yup..you can use bcp for thishttp://databases.about.com/od/sqlserver/a/bcp.htm |
 |
|
|
|
|
|
Export data into notepad