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