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 |
|
gpc44
Starting Member
35 Posts |
 Posted - 2014-02-07 : 05:32:04
|
Hi,how can I export any table/view in XML format with Data Type and Lenght.Background: I want to validate the xml against xsd-schema.-or: What is the best practice....?ThanksNicole  |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-02-11 : 02:42:10
|
| sounds like what you want is a query based on INFORMATION_SCHEMA.COLUMNS and apply FOR XML over it to make it into xml.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Export to XML with datatype