SQL Server Express 2008 R2 Tutorial 8 – Update Statement

http://www.schoolfreeware.com

An Update is used to modify data. To limit the records that are being updated use the Where clause. Before updating the records, it is a good idea to run a Select statement to verify that the correct records will be updated.

Commands Used:
Update
Select
Where
Set
Active
Count