insert into destination_db_name.owner_name.destination_table(col1,col2)
select col1,col2 from source_db_name.owner_name.source_table
--
Vishal Parkar
vgparkar@yahoo.co.in | vgparkar@hotmail.com
"Wes" <wharrison@adcbarcode.com> wrote in message
news:2a7d01c51e80$9b235b80$a401280a@phx.gbl...
> Hi,
>
> could someone give me the syntax to communicate across 2
> databases. e.g. SQL for inserting records from one
> database to another
>
> INSERT INTO Database1
> SELECT FROM Database 2
>
> Both databases are on the same server. I am using SQL 2000.
>
> Thanks!
>
> Wes
Re: BizTalk eating up SQL Server (Virii Behaviour) ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory,...BizTalk Solution Developer... (microsoft.public.biztalk.general)
Re: Relational-to-OOP Tax ... Many SQL vendors has text mining features.... Tutorial D isn't availible in production databases.... The Third Manifesto,2 object functionality and the relational model are ... (comp.object)
DataArchitect Version 3.5 Now On HP-UX ... DataArchitect is a powerful tool that provides ERD capability like PowerDesigner as well as the ability to graphically reverse engineer, create and modify a database through ODBC and perform advanced SQL functions.... Data Architect is an emerging enterprise tool for designing databases at all levels of an organization using the same concepts found in tools costing thousands of dollars! ... Minimize/Maximize feature on diagram objects... (comp.sys.hp.mpe)
Re: COBOL and DB2 vs. Java and DB2 ... the doors off SQL type approaches. ... by "traditional mainframe databases" you mean VSAM datasets connected ... (comp.lang.cobol)
