SQL Server Performance Forum – Threads Archive

Open XML

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

---

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 —————————————-

---

]]>