faqts : Computers : Databases : Microsoft SQL Server

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

13 of 65 people (20%) answered Yes
Recently 1 of 10 people (10%) answered Yes


mssql "UPDATE [...] WHERE [...]" updates ALL records in my table !

May 30th, 2001 06:42
Gary Macey, Michael O\'Shea, Philip Olson,

The criteria entered in your WHERE clause must match all the records in 
the table.
Refine your WHERE clause to narrow down the matching recordset.