update select sql

Solutions on MaxInterview for update select sql by the best coders in the world

showing results for - "update select sql"

1UPDATE YourTable 
2SET Col1 = OtherTable.Col1, 
3    Col2 = OtherTable.Col2 
4FROM (
5    SELECT ID, Col1, Col2 
6    FROM other_table) AS OtherTable
7WHERE 
8    OtherTable.ID = YourTable.ID

1--the simplest way of doing this 
2UPDATE
3    table_to_update,
4    table_info
5SET
6    table_to_update.col1 = table_info.col1,
7    table_to_update.col2 = table_info.col2
8
9WHERE
10    table_to_update.ID = table_info.ID

similar questions

sql update update in sql update sql how to update data in sql sql update query update command in sql updating values in sql sql access update sql update how to update row in sql how to update date value in sql how to update values in sql sql update from select update values in select statement sql sql update with statement update sql sintax sql update record sql update klausel update from table tsql

queries leading to this page

t sql update from select update select tsql update from select update table in ms sql sql server update select sql server update from select update from select sql update from select statement update column sql select query update select sql update into select mssql update from select update sql server query update with select query sql server using select statement in update t sql update from select chnage column values in sql update select sql server update using select sql update sql script select and update update query sql server update set select sql servr update from select sql sql server update table sql update table from select sql update select sql update set column where in query sql update from select script sql update table update from a select statement sql update table from a quey using select queries with update statements how to update a column in sql update select statement sql server update with select select update in sql update with select syntax sql updating in sql update from select sql server update table from another table sql select update select update update select sql sql upfate from select update select sql