Jun 11, 2002 #1 msalvador Programmer Nov 13, 2001 33 0 0 IT hi via script i've to transfert the data from a table in db1 to the same table in db2 db1:table pippo db2:table pippo
hi via script i've to transfert the data from a table in db1 to the same table in db2 db1:table pippo db2:table pippo
Jun 11, 2002 #2 tlbroadbent MIS Mar 16, 2001 9,982 0 0 US Quite simple. Insert db2.dbo.table1 Select * from db1.dbo.table1 Terry L. Broadbent - DBA Computing Links: http://tlbroadbent.home.attbi.com/prog.htm faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions. Upvote 0 Downvote
Quite simple. Insert db2.dbo.table1 Select * from db1.dbo.table1 Terry L. Broadbent - DBA Computing Links: http://tlbroadbent.home.attbi.com/prog.htm faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.