SQL UPDATE Statement – Documentation

TOP (expression): Optional limit on rows to update (SQL Server).
schema_name: Optional schema qualifier.
table_name: The target table.
SET: Defines column assignments.
WHERE: Filters rows to be updated. Omit to affect all rows.

Overview

The UPDATE statement modifies existing rows in a table. It allows you to change column values based on a specified condition.

UPDATE [TOP (expression)] 
    [schema_name.]table_name
SET column1 = expression1,
    column2 = expression2,
    ...
[WHERE search_condition]
[;]

UPDATE Employees
SET Salary = Salary * 1.10
WHERE Department = 'Sales';

UPDATE Products
SET Price = Price - 5,
    Stock = Stock + 20
WHERE Category = 'Electronics';

UPDATE Orders o
SET o.Status = 'Shipped'
FROM (SELECT OrderID FROM Orders WHERE ShippedDate IS NOT NULL) s
WHERE o.OrderID = s.OrderID;