Re: How to Generate Schema for Nested XML with SQL Adapter

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for your help.

Your so nice guys. We decide not to use the sql adatper to generate our
schemas, as we only need to pass the messages out, so we will mannually
assemble the schemas. And the data will also be assembled up from
serveral querys's result.


"Wade Ding 写道：
"
Hi Liu

I think the best solution for your scenario will be create your own SQL
adapter, use XML DOM bulk load.

regards,

wade
<RhettLiu@xxxxxxxxx> wrote in message
news:1164693179.000422.203450@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Kailux4,

It seems ugly, I have more than 10 tables, there will be more than one
hundred fields.

I hope there could be one better choice.

Thank you for your kind help.


"kailux4 D′μà￡o
"
Hi,

the following link helps in controlling xml structure with data from
multiple tables

http://objectsharp.com/blogs/matt/archive/2005/03/22/1560.aspx


"RhettLiu@xxxxxxxxx" wrote:

Dear All.

I have been troubled with SQL Adapter.

I have a query which is used to assemble nested XML from data base,
like

<product>
<interest att1=""/>
<other attb=""/>
</product>

Since we have more than two tables, we could not use "join" to assemble
the XML.

We use nested query like:
SELECT top 3
(SELECT top 2 att1
FROM Interest
for xml auto, type),
(SELECT top 2 attb
FROM Other
for xml auto, type),
FROM Product
FOR XML AUTO, TYPE


But how could I get the schema with SQL Adapter?


I am expecting to get your idea, thanks!


Best Regards.



.

Relevant Pages

  • Dynamic Tables vs EAV
    ... Links for SQL Server Books Online: ... can essentially query and manipulate the nodes of the XML column sets using ...
    (microsoft.public.sqlserver.programming)
  • Re: Is there a way to convert ms sql 2008 tables to XML files?
    ... After looking at the code I made it work, since I removed 2 nVARCHARcolumns from the SQL statement where it is used as an RTF. ... I have the 2 XML files the bad and the good which are below: ... Verdana;}{\f1\fnil\fcharset0 Microsoft Sans ... Here is the actual string copied from the ms sql 2008 which works fine; ...
    (microsoft.public.dotnet.framework.aspnet)
  • thank you
    ... Unfortunately short of a clr proc or function you are unable to ... Change the maximum characters retrieved value for xml data. ... 'path provided by the stored procedure. ... 'If an error occurs catch the message and pipe it back to SQL ...
    (microsoft.public.sqlserver.programming)
  • Re: XML-Speicherung beim SQL Server 2005
    ... > also wenn die XML-Dokumente geparst werden, ... das der SQL Server dafür XQuery einsetzt. ... Struktur von XML. ...
    (microsoft.public.de.sqlserver)
  • Re: Implementation of boolean types.
    ... >> Marshall Spight wrote: ... I think of SQL as bringing the 3VL into popularity, ... world and XML will surely play I roll. ... XML doesn't address data management; ...
    (comp.databases.theory)