truncate table B..t_user
insert B..t_user select * from A..t_userordrop table B..t_user
select * into B..t_user from A..t_user
insert B..t_user select * from A..t_userordrop table B..t_user
select * into B..t_user from A..t_user
truncate table B..t_user
insert B..t_user select * from A..t_user
commit tran