Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008
    Posts
    2

    Unanswered: Join two different database

    any one know the command of compare two field in two different database?

  2. #2
    Join Date
    Aug 2008
    Posts
    2
    just need a sql command to joint the two different database

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Are these two databases on a single instance or two databases on two different instances?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Nov 2002
    Posts
    272
    What you need is a link from one server to the other. Look up linked servers in Books Online.

    (Assuming the databases reside on different servers...)

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i've seen questions like this before -- often what they mean is "just need a sql command to joint the two different table"
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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