Post reply

Insert data from XML file

  • November 6, 2007 at 3:24 am

    #748574

    Ok thanks Adam your example works.

    Is this what's called XQUERY in your INSERT....SELECT?

    Kindest Regards,

  • November 6, 2007 at 11:34 am

    #748792

    Yeah. XQuery really get its power from querying and modifying XML. This is just a method for getting data from xml into SQL Server. You will note that if you use the "query" method you will return xml, while the nodes method is used to return data in a tabular format.


    My blog: http://jahaines.blogspot.com

  • November 8, 2007 at 4:28 am

    #749394

    Thanks Adam.

    Kindest Regards,

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply