sql update from two different database

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

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
pinned-register now
showing results for - "sql update from two different database"
Lisa
19 May 2020
1update table_name1
2set column_name = T2.column_name
3from database_name.dbo.table_name2 as T2
4  where table_name1.ID = T2.ID
Marie
20 Feb 2019
1update table1
2set col2 = T2.col2
3from DataBaseName.dbo.table1 as T2
4  where table1.ID = T2.ID and
5        table1.col2 is null