你说的不太明白，没有说做什么操作。。比如A表中新增一条记录时，B表对应的记录删除。。。可以这样： create table a(a1 int,a2 nvarchar(50)) create table b(b1 int,b2 nvarchar(50)) go insert a values(3,'Game') insert a values(7,'HanMei') insert b values(1,'YangHao') insert b values(2,'NaNa') go create trigger tri_delb on a after insert as declare @var1 int; select @var1=a1 from inserted delete from b where b1=@var1 go insert a values(1,'试试看') select * from b
