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 |
|
chippi
Starting Member
1 Post |
 Posted - 2005-08-29 : 06:01:49
|
| Hi all,I want to write a store precedure to query data from DB and export data to csv file or xml.Please help me to solve this task.Thanks in advance! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-29 : 13:33:28
|
| You can use bcp or DTS to export to CSV. You'll need to use master.dbo.xp_cmdshell to call either from a stored procedure.Tara |
 |
|
|
|
|
|
Export Data to csv file or xml