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:50 pm

    #1243846

    sholliday (10/28/2010)

    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.

    It's a defect. It will be, or has been, fixed.

    I'm also on SQL Server 2008 R2 (x64).

    We're successfully using the XML approach as a data transport mechanism between our .Net SaaS web application and the stored procedures in the database. Works quite well. The XML is a hybrid (Attribute & Element) but mostly Attribute centric.

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]