SQL Server - SET Keyword

The SQL Server (Transact-SQL) SET keyword is used with SQL Server UPDATE statement and it is used to specify which columns and values that should be updated in a table. A SQL Server WHERE clause can be used with the UPDATE statement to update the selected rows, otherwise all the rows will be assigned the updated value.

Syntax

The syntax for using SET keyword in SQL Server (Transact-SQL) is given below:

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition(s);

Example:

Consider a database containing a table called Employee with the following records:

• To update the City and Salary of an employee whose EmpID is 5, the statement will be:

  UPDATE Employee
  SET City = 'Mumbai', Salary = 2900
  WHERE EmpID = 5;
  
  --See the result
  SELECT * FROM Employee
  

  
  

  Now the Employee table will contain following records:

  EmpID	Name	City	Age	Salary
  1	John	London	25	3000
  2	Marry	New York	24	2750
  3	Jo	Paris	27	2800
  4	Kim	Amsterdam	30	3100
  5	Ramesh	Mumbai	28	2900
  6	Huang	Beijing	28	2800