Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition

UPDATE

The UPDATE statement is used to modify column values in existing rows in a table. The UPDATE statement specifies the table to be updated, the columns to update, the new values to assign those columns, and criteria for the rows to updated. Table 21.7 describes the components of an UPDATE statement.

Table 21.7. Components of an SQL UPDATE Statement

Component	Description
UPDATE	Specifies the table to be updated
SET	Specifies columns to update and the new values to assign to those columns
FROM	Specifies the tables to include in the UPDATE statement
WHERE	Specifies the criteria to determine which rows' columns are to be updated

Setting Columns to a Fixed Value with UPDATE Statement

In some cases, you might want to update columns in a table with a fixed ...