Related resources for creating stored procedure using OPENXML
  • Insert Master-Detail Data using Transact-SQL10/20/2012 2:17:59 AM. Microsoft SQL Server 2000 SQLXML allows among other things to manage batch operations in a database, which reduces significantly the need of more than one round-trip to a database. OpenXML is a Transact-SQL statement that allows to represent data in XML format and can be used to insert, update, and delete more than one row (represented by an element) in a table or group of tables.