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 |
|
osirisa
Constraint Violating Yak Guru
289 Posts |
 Posted - 2010-01-27 : 14:41:35
|
| Hi Group:I need your help and wisdom. I have a table with a List of Employee about a (1000) of them. To make an application a little faster. I need to extract the list of Employees from the Employee Table and transfer into XML file to be used by the application via XML instead of an using stored procedure. Thanks for all the help. |
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-01-27 : 15:37:40
|
| I'm not sure if this is what you are looking for, but this query would create the output in an XML format:SELCT * FROM Table FOR XML AUTO |
 |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2010-01-27 : 16:03:56
|
| Thank you Robert |
|
|
|
|
|
|
Pulling SQL Data into an XML file