Entry in Greg Larsen’s series on Learning T-SQL. The series so far:
The basic T-SQL Select Statement Ordering a result set in SQL Server The ins and outs of joining tables in SQL Server Summarizing data using GROUP BY and HAVING The Basics of Inserting Data into a SQL Server Table The Basics of Updating Data in a SQL Server Table
Once data is inserted into a table, data typically needs to be maintained as time goes on. To make changes to an existing row or a number of rows, in a table, the UPDATE statement is used.