能用触发器删除另一张表的记录吗? create trigger tr_aaa on A表for deleteasdelete from B表 where id in(select id from deleted)go 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你的这个deleted.ID在做delete后已经没有了,哪来的等于呀。再想想吧。 create trigger tr_aaa on A表for deleteasif (select count(id) from B表)>0 delete B表 from B表,deleted where b表.id=deleted.IDgo create trigger tr_aaa on Afor deleteasdelete from B where id in(select id from deleted) delete from B where id not in(select id from A) 就是,直接create trigger tr_aaa on A表for deleteasdelete B表 from B表,deleted where b表.id=deleted.IDgo不就完了吗?(对不起,COPY你的程序!) sql变量做表名查询问题 编码树如何调整节点排序 求sql server 2000 获取角色对应的权限信息 SQL 2005还原出错,请高手帮忙,谢谢!![十分火急] 请教:用OPENROWSET打开别的DB时,中文字段查出来都是乱码,怎么解决啊? 一个表能不能有七十多列的字段 时间戳转换日期格式? 数据库的独占问题。 动态写入临时表的问题 请教一个关于游标的问题! 难死我了。一句sql请教 用sql的sum()统计float型数据出现奇怪的错误
for delete
as
if (select count(id) from B表)>0
delete B表 from B表,deleted where b表.id=deleted.ID
go
for delete
as
delete from B where id in(select id from deleted)
create trigger tr_aaa on A表
for delete
as
delete B表 from B表,deleted where b表.id=deleted.ID
go
不就完了吗?
(对不起,COPY你的程序!)