sql update from two different database

Solutions on MaxInterview for sql update from two different database by the best coders in the world

showing results for - "sql update from two different database"

1update table_name1
2set column_name = T2.column_name
3from database_name.dbo.table_name2 as T2
4  where table_name1.ID = T2.ID

1update table1
2set col2 = T2.col2
3from DataBaseName.dbo.table1 as T2
4  where table1.ID = T2.ID and
5        table1.col2 is null

similar questions

update table sql multiple set sql update multiple columns from another table sql update multiple tables multiple replace value mssql how to update the multiple rows in sql mysql update one table from another table multiple columns sql run multiple updates in one query sql oracle update multiple rows put multiple value in a like sql sql select merge multiple values sql query update multiple columns sql server update column based on another table mysql update two tables at once mysql select update same table sql server update multiple columns at once sql update from different table update multiple columns in sql update one column from another column in same table update query for multiple columns

queries leading to this page

sql update from another database sql update from another database table update table from different database how to update data from two different database in sql update record from two diffrent database sql update from two different database sql update with data from another database not working update multiple columns sql sql update from two different database