This section provides examples of using updategrams.
All the examples in this section use the AdventureWorks sample database in Microsoft SQL Server 2005. All the updates are applied to the tables in the AdventureWorks database. For information about restoring the AdventureWorks database, see 利用指令碼重新安裝範例資料庫.
In This Section
- Executing an Updategram by Using ADO (SQLXML 4.0)
Provides a Microsoft Visual Basic application that uses ADO to establish a connection to SQL Server and execute an updategram.
- Executing an Updategram by Using OLE DB (SQLXML 4.0)
Provides a working sample of using OLE DB to execute an updategram.
- Using an Updategram in a Sample ASP Application (SQLXML 4.0)
Provides an Active Server Pages (ASP) application to update customer information in the Person.Contact table in the AdventureWorks database.