I am two different database one is call gmg_order_entry and the other is call gmg_claims I would
I have two different database one is call gmg_order_entry and the other is call gmg_claims both of them have two tables with the same name call zipcodes. However, the gmg_order_entry database zipcodes table is populated and I would like to copy those data to
the gmg_claims table call zipcodes which have the same schema as the gmg_order_entry zipcode tables. I am using Microsoft SQL Server 2000. Please advice how I may accomplished this.
the gmg_claims table call zipcodes which have the same schema as the gmg_order_entry zipcode tables. I am using Microsoft SQL Server 2000. Please advice how I may accomplished this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
INSERT INTO gmg_claims.dbo.zipcodes
SELECT * FROM gmg_order_entry.dbo.zipcod
Work Great Thank u
SELECT * FROM gmg_order_entry.dbo.zipcod
Work Great Thank u
ASKER
INSERT INTO gmg_claims.dbo.zipcodes
SELECT * FROM gmg_order_entry.dbo.zipcod
SELECT * FROM gmg_order_entry.dbo.zipcod
ASKER
dont I need to put on the table name like gmg_claims