Insert Master-Detail Data using Transact-SQL (c-sharpcorner.com)
submitted by 
gbingham(45) 6 years, 2 months ago
Many applications have components that connect, manage, and consume data from a database. If you are designing/building an application that connects to a database to continuously insert, update or delete data, you should keep in mind that each operation will need a round-trip to the database and will consume valuable resources (e.g., network traffic, memory, CPU, etc.). 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.
|category: XML
|Views: 127
tags:
another
Everyones tags:
No tags
Your Tags: