Home Forums Article Discussions Article Discussions by Author Discuss content posted by Nasir Mirza Using T-SQL to Transform XML Data to a Relational Format RE: Using T-SQL to Transform XML Data to a Relational Format

  • December 31, 2009 at 6:56 am

    #1097863

    Graham O'Daniel (12/30/2009)

    How about using OPENXML?

    I find OPENXML to be fairly useful when translating XML to table data.

    Hope this helps!

    -Graham

    NO! See: Stop Using OPENXML

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

    [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]