Best practice Update rows on SQL Server
This is the safest way to update the records.
|
1 2 3 4 5 |
WITH d AS ( SELECT UserID, EmailAddress, Password, Gender, DOB, Location, Active FROM Facebook.Users ) UPDATE d SET Active = 0 |
This is the way you can clearly see what we are going to update.
Expression: WITH
This instruction specifies a temporary named result set, known as a common table expression. It is derived from a simple query and defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE or MERGE statement.
This is stack flow’s best answer stackflow
Note: Please, be careful when updating records in a table, Notice the WHERE clause in the UPDATE statement. The WHERE clause specifies which record(s) that should be updated. If you omit the WHERE clause, all records in the table will be updated.
