你是要每次都这样,还是只是一次?是要自动的?还是要手工的?如果是自动的,就要写个触发器了,反正不管是手动还是自动都一样的方法。insert b select * from A where 条件delete A where 条件就行了。触发器的话,我也帮你写个吧~~Create trigger triggername Afor delete as insert into B select * from deleted go注意:deleted是个临时表~~~