Tutorials
Search…
Lesson 18. Updating Data
You update data with the SQL UPDATE statement. When you update data and you only want to update a single row, make sure you have a filter on your query of exactly what you are updating, otherwise you are going to wind up updating the entire table.

UPDATE Syntax

UPDATE --the table you want to update
SET --the new value in the column you want to change
WHERE --The conditions you specify

Examples

Simple Update Example
USE Demo
DECLARE @Person AS TABLE (ID INT, FName NVARCHAR(100), LNAME NVARCHAR(100))
INSERT INTO @Person(ID, FName, LNAME)
SELECT 1,'Bob', 'Wakefield'
UNION
SELECT 2,'Vanna','White'
UNION
SELECT 3,'Pat','Sajak'
SELECT *
FROM @Person
WHERE ID = 1
--Begin update process
UPDATE @Person
SET LNAME = 'Johnson'
WHERE ID = 1
SELECT *
FROM @Person
WHERE ID = 1
Copy link
On this page
UPDATE Syntax
Examples