Re: Is there a way to convert ms sql 2008 tables to XML files?
- From: "Eric S" <NoSpam@xxxxxxxxxxx>
- Date: Fri, 12 Jun 2009 13:16:06 -0400
OK Thanks Erland.
"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message news:Xns9C28A4C25414FYazorman@xxxxxxxxxxxx
Eric S (NoSpam@xxxxxxxxxxx) writes:Is there a way to convert ms sql 2008 tables to XML files?
Say I have several tables related to each other and I want to create the
hierarchy of the data such as parent child within the XML
These are small tables where I store the data of menu options and sub
options etc...
Check out the FOR XML clause in Books Online.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Is there a way to convert ms sql 2008 tables to XML files?
- From: Eric S
- Re: Is there a way to convert ms sql 2008 tables to XML files?
- From: Erland Sommarskog
- Is there a way to convert ms sql 2008 tables to XML files?
- Prev by Date: RE: isolate rows where name contains a pre/suffix or 4 individual spac
- Next by Date: Re: Copy File and error code
- Previous by thread: Re: Is there a way to convert ms sql 2008 tables to XML files?
- Next by thread: When are TRC files created?
- Index(es):
Relevant Pages
|
