Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    2

    Unanswered: Stored procedure using Two database's

    I need to Update a table in DataBase1 using data from DataBase2 using stored procedure. Any idea how to do it?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    My guess is that you will need to write a java or other external stored procedure. It cannot be done in SQL since you can only be connected to one database at a time in SQL.

    HTH

    Andy

Posting Permissions

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