Changing Data Using the WHERE Clause

The WHERE clause performs two functions:

If no WHERE clause is specified all rows in the table are updated.

This UPDATE statement implements a name change for one of the shippers:

UPDATE Northwind.dbo.Shippers

SET CompanyName = 'United Shippers'

WHERE CompanyName = 'United Packages'

  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.