请问这个触发器怎么写? CREATE TRIGGER 触发器001 ON a FOR DELETEASDELETE b FROM b JOIN ON DELETED ON b.id=DELETED.id 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create trigger tr_delete on afor deleteasdelete b where exists(select 1 from deleted a on a.id=b.id) 在a中创建一个delete触发器delete from b where id=deleted.id CREATE TRIGGER TRI_delON a AFTER DELETEASDELETE b FROM b WHERE id=DELETED.id; 触发器同楼上的兄弟,另外也可以这样:alter table badd constraint fk_a_b foreign key([id])references a([id])ON DELETE CASCADE这样删除a表的时候就会删除相应b表中的数据. create trigger del_trig on afor delete asdelete bfrom deletedwhere b.id=deleted.id create trigger del_trig on afor delete asdelete bfrom b join deleted on b.id=deleted.aid 各位高手帮我看看 在线等一条语句 求救SQL语句,怎么实现统计 求高手解释一下,这2个数据库可不可以删掉。 关于SQL2005登陆选择服务器名称的问题 诚心邀请,请教数值分析或数据挖掘高手 winxp home版下是否能安装MSDE 2000,送分!!! 一个简单的问题,我的数据库使用不了。 我想知道现在用得最多的大型数据库系统是哪些? sql7.0 与 sql 2000 有什么不同 导出数据失败,因为目标服务器没有源服务器的同名登录,求助! 字段名含有"/"怎么办啊
for delete
as
delete b where exists(select 1 from deleted a on a.id=b.id)
delete from b where id=deleted.id
ON a
AFTER DELETE
AS
DELETE b FROM b WHERE id=DELETED.id;
add constraint fk_a_b foreign key
([id])
references a
([id])
ON DELETE CASCADE这样删除a表的时候就会删除相应b表中的数据.
for delete as
delete b
from deleted
where b.id=deleted.id
for delete as
delete b
from b join deleted on b.id=deleted.aid