How do I UPDATE from a SELECT in SQL server

Question

can we  update a table with SELECT? A temporary table containing the values and and  update another table using those values  can we do it

Answer 1

In SQL Server, it is possible to insert rows into a table with INSERT, SELECT statement:

INSERT into TABLE (col1, col2, col3)
SELECT col1, col2, col3 
FROM OLD_TABLE 
WHERE sql = 'cool'

 update a table with SELECT:

UPDATE Table SET column1, column2
SELECT column1, column2 
FROM OLD_TABLE
WHERE sql = 'cool'
WHERE Table.id = OLD_TABLE.id