Avatar of 1030071002
1030071002
Flag for United States of America asked on

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.
Microsoft SQL Server

Avatar of undefined
Last Comment
1030071002

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rainer Jeschor

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
1030071002

ASKER
insert into zipcodes

dont I need to put on the table name like gmg_claims
1030071002

ASKER
INSERT INTO gmg_claims.dbo.zipcodes
SELECT * FROM gmg_order_entry.dbo.zipcodes

Work Great Thank u
1030071002

ASKER
INSERT INTO gmg_claims.dbo.zipcodes
SELECT * FROM gmg_order_entry.dbo.zipcodes
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck