UPDATE (SQL Statement)
Description
Changes existing data in a table.
Syntax
UPDATE { table_name | view_name }
SET { column_name = expression } [ ,...n ]
[ FROM { table_name | view_name } [ ,...n ] ]
[ WHERE < search_condition > ]
Example
UPDATE table1
SET c1 = 9
Detail
UPDATE permissions default to members of the sysadmin fixed server
role, the db_owner and db_datawriter fixed database roles, and
the table owner. Members of the sysadmin, db_owner, and
db_securityadmin roles, and the table owner can transfer permissions to
other users.
SELECT permissions are also required for the table being updated if the
UPDATE statement contains a WHERE clause, or if expression in the SET
clause uses a column in the table.
See Also
SELECT (SQL Statement) |
