How to write or append to text file using sql?

Question

i need to call sqlcmd from stored procedure to export table to text file?

+1 for the pic. Check this link simple-talk.com/sql/t-sql-programming/… — hgulyan
– hgulyan, Commented May 12, 2010 at 12:03

Pranay Rana · Accepted Answer · 2010-05-12 11:48:12Z

6

by the following way you can do this

exec master..xp_cmdshell 'echo pranay test application > d:\file.txt'

answered May 12, 2010 at 11:41

Pranay Rana

177k37 gold badges244 silver badges267 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

i can't append to file like this

The > redirect overwrites, >> will append

Guess i'm making an easy mistake, but the file is looking like chinese characters instead of the simple "test" i am echoing-in.