Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2011
    Posts
    2

    Question 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

  2. #2
    Join Date
    Aug 2008
    Posts
    147
    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
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

  3. #3
    Join Date
    Jun 2011
    Posts
    2
    yes its on the same sql server.thanx ..i'll try... i haven't done these before i still a student ...again thanx 4 da info

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •