Re: Newbie Q: How to Combine data from two tables from two different databases

SELECT ... FROM DB1.dbo.tblname

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


"Michelle" <nospam_mbytwo-news@xxxxxxxxxxxx> wrote in message
news:12ak1vpj5epfn00@xxxxxxxxxxxxxxxxxxxxx
Hi

I have two separate SQL server databases: DB1 and DB2

Both databases contains similar tables and I have to combine some of the like tables together.
If I create an INSERT INTO statement, how do I reference the DB1 and DB2 specific tables?

I will be appreciative for responses or links to areas that I can further read up.

TIA
Michelle




.

Relevant Pages

  • SQL DB to MySQL
    ... We have SQL Server 2000 databases residing on one server, ... DB1 contains the main data, ... DB2 contains data about the most recent changes to DB1, The key, table ID, ... Our plan is to schedule a DTS package to update the MySQL database. ...
    (microsoft.public.sqlserver.dts)
  • Re: Newbie Q: How to Combine data from two tables from two different databases
    ... I have two separate SQL server databases: ... If I create an INSERT INTO statement, how do I reference the DB1 and DB2 ...
    (microsoft.public.sqlserver.tools)
  • Newbie Q: How to Combine data from two tables from two different databases
    ... I have two separate SQL server databases: ... If I create an INSERT INTO statement, how do I reference the DB1 and DB2 ...
    (microsoft.public.sqlserver.tools)
  • Re: Eine Tabelle in der Datenbank 1 mit Formular aus Datenbank 2 f
    ... DB2 dient zur Erfassung der Mitarbeiter und der Schulung, DB1 dient der ... da gibt es eben bereits das Formular mit den Stammdaten. ... Stammdatentabelle DB2 auf, geht in das Formular und legt den MA an, schließt ...
    (microsoft.public.de.access)
  • Re: physikalische Datenbank-Struktur
    ... (im Weiteren sei DB1 die "Haupt-"Datenbank, ... deren Ziel-Tabellen in DB2 liegen): ... Deutliche Verbesserungen konnte ich feststellen, ... mit DB2, auch wenn ich diese Verbindung weiter gar nicht nutze. ...
    (microsoft.public.de.vb.datenbank)
Loading