Answers for "sql server update from"

sql update from select

UPDATE YourTable 
SET Col1 = OtherTable.Col1, 
    Col2 = OtherTable.Col2 
FROM (
    SELECT ID, Col1, Col2 
    FROM other_table) AS OtherTable
WHERE 
    OtherTable.ID = YourTable.ID

Update Query in SQL Server

UPDATE table1
  SET column2 = 'Your Text', column3 = 45000
  WHERE column1=5