create trigger t_update_B on B表 fro delete
as
delete a表 where a表.category=delete.categorygo
as
delete a表 where a表.category=delete.categorygo
解决方案 »
- 问个sql的,不懂是什么问题,那就不写题目了吧
- 数据导入问题
- update db set a=0 where x=1 当x=1有多个时不能执行?有其他写法吗?
- 我装的是sql server 2000sp4为什么用金山网镖扫描系统时存在sp3漏洞?
- Fnumber改变如下面所示:语句该怎么写 sql server2008
- 游标三层循环的存储过程,求优化
- SQL Server怎么突然连不上了
- ●●●●●请大虾帮忙分析一下问题出现的原因,200分敬上决不食言。详情请进!!!●●●●●
- ASP如何连上SQL Server服务器????10分送上!!
- 关于一个sql的问题
- 为什么我要调试SQLSERVER里面的过程时,系统提示‘如果你用‘本地系统帐户’登陆,那么可能无法调试过程!’
- 在存储过程中如果接收返回行数的参数?
for delete
as
delete a表 where category in (select id from deleted)
go
FOR INSERT
AS
insert db2..tabSlave select * from insertedCREATE TRIGGER 名2 ON dbo.tabMain
FOR update
AS
update db2..tabSlave set 列=aa.列 from inserted aa where aa.编号=db2..tabSlave.编号
CREATE TRIGGER 名3 ON dbo.tabMain
FOR delete
AS
delete db2..tabSlave where 编号 in (select 编号 from deleted)
add Foreign Key(category)
References category (id)
on delete cascade
on update cascade