XML new..Need help

[glebreck]

I have gotten into some new software. All the websites I have created are dynamic and use SQL databases.

The software works with xml data, but as all my info is heald in a SQL server how do I get that data into xml format?

Is there a such thing as a xml page that whenever accessed gets the latest data from the sql server?

 

[simonchristieis]

you can export the data from sql server using "for xml explicit"

example:

example:

select 1 as Tag,
null as Parent,
Foo as [Foo!1!Foo_e],
Bar as [Bar!2!Bar_e!element]

Union all

select 2 as Tag,
1 as Parent,
Foo as [Foo!1!Foo_e],
Bar as [Bar!2!Bar_e!element]

for xml explicit

 

[JontyMC]

Yep, or you could create you own XML programmatically.

Jon

"I don't regret this, but I both rue and lament it.