求个触发器 create trigger DelForT1on T1for delete as delete from T2 where T2.id in (select D.id from Deleted) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create trigger DelForT1 --更有效一点吧on T1for delete asdelete a from t2 join deleted b on a.id=b.id create trigger triggerT1 on T1for delete asdelete T2 from Deletedwhere T2.id = Deleted.ID 分组查询 高分求購:SQL總結 求救:如何缩短执行时间? 使用事务,如果对一个表查询或操作太多,会假死机?大家遇到过吗? 如何将如下access 语句 转成 sql server 2000 SQL 备份 中文路径 创建数据库出错 帮忙设计如下的结果表 我对SQL一窍不通,想知道SQL都有什么版本,现在一般都用什么版本?很容易得分的啊! 请教一个视图的问题! 触发器问题 问一条SQL语句,ok后立即给分..
on T1
for delete
as
delete a from t2 join deleted b on a.id=b.id
on T1
for delete
as
delete T2 from Deleted
where T2.id = Deleted.ID