Re: SQL from XML

Discussion in 'XML' started by Martin Honnen, Apr 15, 2008.

  1. 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/
    Martin Honnen, Apr 15, 2008
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. dSchwartz
    Replies:
    1
    Views:
    343
    Bryant Likes
    Mar 6, 2004
  2. Harry Zoroc
    Replies:
    1
    Views:
    915
    Gregory Vaughan
    Jul 12, 2004
  3. Stylus Studio
    Replies:
    0
    Views:
    400
    Stylus Studio
    Jul 26, 2004
  4. ecoolone
    Replies:
    0
    Views:
    742
    ecoolone
    Jan 3, 2008
  5. Erik Wasser
    Replies:
    5
    Views:
    429
    Peter J. Holzer
    Mar 5, 2006
Loading...

Share This Page