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 |
|
mrdotnetid
Starting Member
8 Posts |
 Posted - 2007-01-28 : 21:27:09
|
| Hello team,How to create xml file that's contain all data in one database.I Need script sql for it.Thx Rudianto |
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2007-01-30 : 16:18:29
|
| Per table you can do something like the following:SELECT T.C1, T.C2FROM TFOR XML AUTO, ELEMENTSYou can then copy and paste or right click and save the output.There must be another, more global [i.e. for database] method though ... |
 |
|
|
|
|
|
Create Xml File