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