• Its all about how the columns in the with are matched when you don't specify an xpath literal i.e

    with (name varchar(100)

    ,age int)

    With attribute centric mapping this will look for attributes of the elements matched in the OPENXML clause, i.e. @name and @age in

    whereas element centric mapping looks at sub elements. i.e.


    Simon Sabin
    SQL Server MVP

    http://sqlblogcasts.com/blogs/simons