Help for older versions available.
Page last updated 05 February 2021
Published 16 November 2017
The UPDATE statement has neither a WHERE nor an INNER JOIN clause, and it will update every row in the table.
SQL Code Guard
Didn't find what you were looking for?
Tips and how-to guides for Redgate products
Easy to follow video courses
Ask, discuss, and solve questions about Redgate's tools
Events & Friends
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal