SQL Server: Update data in a Table using UPDATE Statement

SQL Server supports the standard SQL to update the data in the table. Use the UPDATE TABLE statement to update records in the table in SQL Server.

Syntax:

UPDATE table_name SET column_name1 = new_value, column_name2 = new_value, ... [WHERE Condition];

Note that the WHERE clause is optional, but you should use it to update the specific record. An UPDATE statement without the WHERE clause will update values in all the rows of the table.

Here we will update data in the Employee table shown below.