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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2009-11-10 : 09:39:40
|
| I created a store procedure, getOrder, to select data.How to export "getOrder" to a xml file in d:\order? |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2009-11-10 : 10:47:33
|
| Try using the "for XML" keyword in the select statement. See BOL.Avoid XML when possible. Certaintly don't use XML for transferring data between systems.An infinite universe is the ultimate cartesian product. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-10 : 13:00:08
|
| http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=9336 |
|
|
|
|
|
|
Export sp to xml