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 |
|
sqlilliterate
Starting Member
40 Posts |
 Posted - 2008-01-24 : 05:26:16
|
| All,I ve the following Query which will give the output in XML format.select * from <Table_Name> For XML autoI wanted to store this output in a .Xml file at my local machine.can u pls. provide the syntax to achieve the same.Thanks, |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-24 : 05:50:56
|
| use bcp._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
 |
|
|
|
|
|
Store the result in a .XML file