Showing posts with label fld2. Show all posts
Showing posts with label fld2. Show all posts

Sunday, February 19, 2012

Inserting Record to db1.table from db2.table

Hello!
Can we do this in SQL2000?
Insert into <db1>.<tablename> (fld1,fld2...) Select fld1,fld2 from <db2>.<tablename>
Assuming that these two tables have the same fields but reside different database.
Thanks in advance
bernieinsert into db1.dbo.table select * from db2.dbo.table