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?

Answer 1

by the following way you can do this

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

more about this : http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/how-to-copy-data-append-data-into-files-