Insert Delete Update MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Insert Delete Update
  4. The syntax of the UPDATE statement
UPDATE table_name
SET column_name_1 = expression_1 [, column_name_2 = expression_2]...
[FROM table_source [[AS] table_alias]
[WHERE search_condition]