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 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.