在原表中将这些查到的记录自动的删除掉~

注意。查询的记录是随机的，不是固定条件的。。所以我想在查询完了后就能够一并删掉。。

谢谢各位~~

楼主定义触发器就可以搞定了，不用那么麻烦：
create trigger tri_test
on A
before update         --注意：关键是这里的before ,如果没有，那原始数据就不会保存到变量中去
as
declare @name varchar,@no varchar,@id int,@shu_liang int
begin
        select @name = name from deleted
        select @bian_hao = bian_hao from deleted
        select @id= id from deleted
        select @shu_liang = shu_liang from deleted
        if (@name<> (select name from inserted) and @bian_hao<> (select bian_hao from inserted))
           begin
                 insert into 表B values(@id,@name,@bian_hao,@shu_liang)
           end
         
end

谢谢了。。。我自己搞定了！~~~不过分还是给你。。。。你是唯一一个理我的。。。