Unanswered: Update table in a database from another databse
i have a problem i need to update a database table from another database in the sql server.wondering if some can help me how to make this happen .i have no clue to startup this.some help will be grateful .thanx
Assuming the two databases (source & target) are on the same SQL Server - it's a matter of referencing the other database in the statement using a multip part reference.
If the source & target are on separate SQL Servers - set up a Linked Server on the target database to the Source database.Ensure you have relevant permissions on the databases. Then reference as a multipart reference in your UPDATE statement