database in sql server

Accepted answer

1/ You said 'complex' in your question 3 times. You don't know the answer. If you don't know the answer, why are you adding 'complex' to it. It may be complex, it may not be complex. We don't know.

2/ You mention 'your value' in your query. That is not quite correct. It must be a column from tb2 in db2. Otherwise what is the purpose of going to another database? Right?

3/ If point 2 is correct, then there must be a joining key columns in both the tables. You didn't mention that one.

4/ If point 3 is correct, you can try something as following in some test environment on some test data. Verify then use on actual tables.

UPDATE t1
SET t1.[column] = t2.[column]
FROM [dbo].[Table1] t1
INNER JOIN [AnotherDB].[dbo].[Table2] t2 ON t1.[id] = t2.[id];

Amudhan Kuppan8y ago

Thank you Nitin

Amudhan Kuppan8y ago

Thank you