delete触发器问题 我想用触发器删除两个表中的记录有两个表a ,b关联字段 id如我在页面中提交id 我想删除两个表中记录触发器怎么写谢谢了! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create trigger tri_delon afor delete as begindelete b from b,deleted where b.id=deleted.idend 不用触发器,用两个语句delete a where id=输入的iddelete b where id=输入的id create trigger test on a for deleteas if delete (a)begin delete b from b,deleted d wehre b.id =d.idend create trigger tri_deon afor delete as begindelete b from b inner join deleted d on b.id=d.idend create trigger test on a instead of delete as delete b from b,deleted d wehre b.id =d.id end 在sql2005 中碰到的问题 SqlServer2005 iis7 安装问题 sql小问题请教 SQL查询问题,按要求GROUP BY以后,列出统计表。谢谢。 access 里面不能用嵌套的 distinct 求解决办法 无法在当前安全上下文下访问数据库 "model" 为什么sqlserver 2000 在安装的完之后,服务器开不了?? 关于SQL server 的问题 提个菜问题,有关触发器的定位 数据库规划问题? 不一样的行转列? 急求,在VB中查询出MSSQL记录集,如何在记录集中增长一个字段,新增这个字段的值是自动增加的
on a
for delete
as
begin
delete b from b,deleted where b.id=deleted.id
end
delete a where id=输入的id
delete b where id=输入的id
for delete
as
if delete (a)
begin
delete b
from b,deleted d
wehre b.id =d.id
end
create trigger tri_de
on a
for delete
as
begin
delete b from b inner join deleted d on b.id=d.id
end
create trigger test on a
instead of delete
as
delete b
from b,deleted d
wehre b.id =d.id
end