delete from A where 学号... delete from B where 学号...
delete from A where 学号 in (select 学号 from B where 学号=XXX )
conn.Execute("delete from 表名1 where 学号=XXXX") conn.Execute("delete from 表名2 where 学号=XXXX")
CREATE Trigger T_A On A For Delete AS Declare @xh Varchar(5) select @xh=A_xh from Deleted begin tran delete from B where B_xh=@xh If @@Error <> 0 Begin Raiserror('删除失败!!!',16,-1) Rollback transaction Return -1 End commit tran
delete B where 学号...
delete table2 where 学号=
delete from B where 学号...
in
(select 学号
from B
where 学号=XXX
)
conn.Execute("delete from 表名2 where 学号=XXXX")
AS
Declare @xh Varchar(5)
select @xh=A_xh from Deleted
begin tran
delete from B where B_xh=@xh
If @@Error <> 0
Begin
Raiserror('删除失败!!!',16,-1)
Rollback transaction
Return -1
End
commit tran