Chapter 1

The WHERE clause tells SQL Server which row in the table to update. You're not limited to updating a single record. If the WHERE clause selects multiple records, they are all updated, as in this example: UPDATE Customers. SET Country = 'United States' WHERE Country = 'USA' You can even update every row in a table by leaving out the WHERE clause: ................
................