A question related to sqlserver and xml schemas/xdr schemas.

[anjali77]

This question is related to sqlserver and xml schemas/xdr schemas
I want to retrieve data from sqlserver in the form of xml format.

suppose i have data
<node1>
<node2>
<node3>
I have to keep relationship(foreign key) between node1 and node3.
I think its not possible to keep relationship to node1 and node3 omitting node2.

Is there any way to keep relationship between node1 and node3 and get the data??
my friend told that its possible by using xdr schemas.

Can anyone help me in this regard.

Thanks for your help

[Ejaz]

I'm not sure but try the post

HOW TO: SQL Server data to XML data?

if u just modify the query according to multiple tables, u'll get the results of multiple tables as well.

Try it out, this may be helpful for u.

Regards,

Ejaz.