SQLConfiguration SQLConfiguration


CRUD Statements  «Prev  Next»
Lesson 3 Overview of updating data
Objective Describe how to update data with Transact-SQL.

Overview of Updating Data in SQL-Server

To update data in a table, you use the UPDATE Transact-SQL statement. When updating data, you must specify the names of the specific columns that you are going to update.
The UPDATE statement uses the following general syntax:



{ INDEX (index_val [,...n])
 | FASTFIRSTROW
 | HOLDLOCK  | PAGLOCK
 | READCOMMITTED
 | REPEATABLEREAD

query_hint syntax

IDENTITY column

Unlike an INSERT statement, an UPDATE statement cannot update the values of an IDENTITY column.

In the next lesson, you will learn about the DELETE statement.