SQL Server Performance
  1. sramesh New Member

    Hi ,
    Any one please explain with openxml command with example.
    what is mapping flags in openxml



    Thanks
    S. Ramesh
  2. dineshasanka Moderator

    OPENXML provides a rowset view over an XML document. Since a rowset is simply a set of rows that contain columns of data,

    OPENXML is the function that allows an XML document to be treated in the familiar relational database format. It allows for the passing of an XML document to a T-SQL stored procedure for the updating of data.

    Check thishttp://www.sql-server-performance.com/jb_openxml.asp

    ----------------------------------------

Share This Page