Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)