This topic has not yet been rated - Rate this topic

Updating Data in a Table

SQL Server 2008 R2

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 provides the following ways to change data in an existing table.

In This Section

Changing Data by Using UPDATE: Describes how to use the UPDATE statement to update data in specific rows in a table or view.
Changing Data by Using a Cursor: 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.
Changing ntext, text or image Data: Describes how to use the UPDATETEXT statement to update specific ntext, text, and image values.

Reference

UPDATE (Transact-SQL)

UPDATETEXT (Transact-SQL)

Other Resources

Inserting Data into a Table

Deleting Data in a Table

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD