Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Manila, Philippines
    Posts
    20

    Unanswered: 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


    bernie

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    insert into db1.dbo.table select * from db2.dbo.table

Posting Permissions

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