Home Forums Article Discussions Article Discussions by Author Discuss content posted by Mohd Nizamuddin Sending multiple rows to the Database from an Application: Part II RE: Sending multiple rows to the Database from an Application: Part II

  • October 28, 2010 at 2:28 pm

    #1243837

    Mauve (10/28/2010)

    I see references to OPENXML in the postings.

    Don't use OPENXML! Use XQuery. See the following SQL ServerCentral article:

    http://www.sqlservercentral.com/blogs/michael_coles/archive/2008/01/20/stop-using-openxml-please.aspx

    True, but BE WEARY of element based xml depending on your Sql Server Version.

    http://connect.microsoft.com/SQLServer/feedback/details/250407/insert-from-nodes-with-element-based-xml-has-poor-performance-on-sp2-with-x64

    Note, there are more versions affected than the url suggests.