假设删除表table1中的记录时,同时删除表table2中相同id值的记录
则创建触发器如下:
CREATE TRIGGER deletetable1 ON [table1]
FOR DELETE
AS
delete table2 from inserted where id=inserted.id
则创建触发器如下:
CREATE TRIGGER deletetable1 ON [table1]
FOR DELETE
AS
delete table2 from inserted where id=inserted.id
解决方案 »
- 100分求一个SQL
- 探讨一下:可以写成一句的SQL语句,是否有必要写成存储过程?
- 请问各位大侠:if exists(select @creator=creator from t_directsendpublication where id=(select sendpubid from inserted))这条语句
- 大家来解析一下这个SQL语句
- 带权的有向无环图如何存储
- 请问XP 下哪一个版本能装SQL server 2000 标准版?
- sql语句求助
- 怎样从数据库(sql server 2005)中查看应用程序访问数据库的连接方式?
- 这句复杂的SQL语句该怎么写?请SQL 高手帮忙,顺便讲一下JION的几个用法
- SQL
- 有关触发器的一个小问题
- 高手请进
为什么不起作用,如何修改?CREATE TRIGGER boarddelete
ON [BBsBoard]
FOR DELETE
AS DELETE BBsArticle FROM inserted WHERE Board=inserted.Boardid
ON [BBsBoard]
FOR DELETE
AS DELETE BBsArticle FROM inserted WHERE Board=inserted.Boardid