Updating Data in a Table
After the tables have been created and the data added, changing or updating data in the tables becomes one of the day-to-day processes in maintaining a database. SQL Server 2005 provides the following ways to change data in an existing table.
In This Section
| Topic | Description |
|---|---|
Describes how to use the UPDATE statement to update data in specific rows in a table or view. |
|
Describes the database application programming interfaces (APIs) that support options for updating data at the current position of a result set. Transact-SQL server cursors also support updating data at the current row of a cursor. |
|
Describes how to use the UPDATETEXT statement to update specific ntext, text, and image values. |
See Also
Other Resources
Inserting Data into a Table
Deleting Data in a Table
UPDATE (Transact-SQL)
UPDATETEXT (Transact-SQL)