Creating Procedure to automate dumping from one database to other

[kiran kumar]

Hi All,

Please look into following issue. I want to dump data from database A.table X to database B.table Y. Table X has already one row inserted. I want to dump remaining data without duplicating the existing data.

use database A
create table X(no int,name varchar(10));
insert into X values(1,"AAA");
insert into X values(2,"BBB");
insert into X values(3,"CCC");

use database B
create table Y(no int,name varchar(10));
insert into Y values(1,"AAA");

Can you help me out in writing a procedure for updating records in this way..


thanks
kiran