SET VS. SELECT in SQL Server

SET and SELECT both key words are used to Assign Variables in SQL Server. SET and SELECT both specifies the columns to be changed and the new values for the columns. The values in the specified columns are updated with the values specified in the SET and SELECT in all rows that match the WHERE clause search condition. If no WHERE clause is specified, all rows are updated.

Read more at http://www.dotnetfunda.com/articles/article752-set-vs-select-in-sql-server-.aspx

Author: Chikul