⟩ How To Update Values in a Table with UPDATE Statements in MS SQL Server?
If you want to update some values in one row or multiple rows in a table, you can use the UPDATE statement. The tutorial script below shows a good example:
SELECT * FROM ggl_links WHERE id = 101
GO
id url notes counts created
101 www.rendc.org NULL 0 2006-04-30
UPDATE ggl_links SET counts = 999, notes = 'Good.'
WHERE id = 101;
GO
(1 row(s) affected)
SELECT * FROM ggl_links WHERE id = 101
GO
id url notes counts created
101 www.rendc.org Good. 999 2006-04-30
As you can see, the SET clause takes column and value pairs to provide new values, while the WHERE clause defines which row to apply the update.
