SQL from XML

[David Gray]

Hi all,

Ok using Visual Studio 2005 Pro I've generated the .xsd schema.

Now is it possible to generate the "create table" SQL statement from
ether of these?

There appears to be nothing obvious in VS2005 to do this.

Dave

[Martin Honnen]

Re: SQL from XML

David Gray wrote:

Ok using Visual Studio 2005 Pro I've generated the .xsd schema.
>
Now is it possible to generate the "create table" SQL statement from
ether of these?
>
There appears to be nothing obvious in VS2005 to do this.

I am not sure there is a SQL creation feature.
If you want to import XML into MS SQL Server 2005 then one way is to use
OPENXML <http://msdn2.microsoft .com/en-us/library/ms175160.aspx>
And there is a bulk load feature:
<URL:http://msdn2.microsoft .com/en-us/library/ms171993.aspx>

--

Martin Honnen

http://JavaScript.FAQTs.com/