database in sql server

Question

hi,

iam amudhan,

i have one doubt please rectify it 

i need complex code for this 

Create one script to update table of another database

i.e I am in database a so update table "test" on database base b

already i know for this query but it is simple query i try but i need complex code anyone please help me 

iam use this query

update db1.dbo.tb1

set value = 'your value'

from db2.dbo.tb2

where condition;

but i need complex code please anyone help me