Update rows on SQL Server
Update rows on SQL Server

Update rows on SQL Server
Essentially, a poka-yoke is a safeguard that avoids having problems in the SQL statements, in this case we can avoid perhaps deleting an entire table in the absence of the WHERE A=?? statement.
WITH is the safest way to update the records.

WITH d AS 
         (
           SELECT UserID, EmailAddress, Password, Gender, Location, Active  FROM codegr.Users
         )
UPDATE d SET Location = 'amsterdam'

What Is the WITH Clause in SQL?

Sometimes, you face a complex problem that cannot quickly be answered via a single SQL statement.

The WITH clause is very equivalent to creating tables. When you create a table needs to give it a name, this name essentially acts as a table name in the main SQL statement.

The benefits of the usage of instruction WITH are that does not create a table or a view, the tables associated with the WITH statement disappear after the main SQL statement is executed, and there is nothing to drop or clean.