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 |
|
Swati Jain
Posting Yak Master
139 Posts |
 Posted - 2007-09-21 : 06:45:54
|
| HiIs there any tool or the sql query which can convert a sql tableinto xml (output as xml contents) or the xsd schema? or vise versa without writting the code |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-21 : 08:32:15
|
| look into FOR XML construct in T-SQLif you already have data in a dataset you can call it's WriteXml method_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-21 : 08:43:21
|
quote:
Originally posted by spirit1
look into FOR XML construct in T-SQLif you already have data in a dataset you can call it's WriteXml method_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com
But I dont understand on what OP said on without writting the codeMay be OP doesnt want to write SQL  MadhivananFailing to plan is Planning to fail |
|
|
|
Swati Jain
Posting Yak Master
139 Posts |
Posted - 2007-09-21 : 09:26:31
|
| I mean to say ,Whether it is possible with any wizard like DTS or with any sql query without writing asp.net code |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-09-21 : 10:09:41
|
if you use FOR XML, stay away from FOR XML EXPLICIT. it is a pig to write and maintain. use FOR XML PATH if your xml structure is even slightly complex and you are on 2005.
elsasoft.org |
|
|
|
nirene
Yak Posting Veteran
98 Posts |
Posted - 2007-09-29 : 06:02:34
|
| Hai Swathi,Select Field1,Field2 from Table for XML AutoNirene |
|
|
|
|
|
|
Sql table to xml file