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 |
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
 Posted - 2008-07-08 : 04:53:56
|
| Hi., how to generate a XML file., that needs to be stored in a particular location for example in c: |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-08 : 04:56:15
|
| you mean from table? then use FOR XML. |
 |
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2008-07-08 : 04:58:58
|
quote:
Originally posted by visakh16
you mean from table? then use FOR XML.
I generated XML output using the for xml statement, but i need to export it as a xml file to a specified location., how to do that. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-08 : 05:36:31
|
quote:
Originally posted by karthik_padbanaban
quote:
Originally posted by visakh16
you mean from table? then use FOR XML.
I generated XML output using the for xml statement, but i need to export it as a xml file to a specified location., how to do that.
http://msdn.microsoft.com/en-us/library/ms191184.aspx |
|
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2008-07-08 : 06:56:21
|
| the above states how to import mostly., how could i create a xml file with the resulted xml output and how could I store that in a specified loacation through a stored procedure |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-08 : 06:58:34
|
quote:
Originally posted by karthik_padbanaban
the above states how to import mostly., how could i create a xml file with the resulted xml output and how could I store that in a specified loacation through a stored procedure
Read it fully especially towards the end on "E. Bulk exporting XML data"
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
how to generate a XML file from sql server 2005