DELETE触发器
来源:互联网 发布:c语言编写的小游戏代码 编辑:程序博客网 时间:2024/05/24 06:52
CREATE TRIGGER [Delete_TopAlexa] ON [dbo].[tb_WebSite]
FOR DELETE
AS
BEGIN TRANSACTION
delete from tb_alexa where websiteid=(select websiteid from deleted)
delete from tb_top100 where websiteid=(select websiteid from deleted)
IF (@@ERROR <> 0) -- 如果有错误
BEGIN
ROLLBACK TRANSACTION -- 回滚
END
COMMIT TRANSACTION -- 提交事务
FOR DELETE
AS
BEGIN TRANSACTION
delete from tb_alexa where websiteid=(select websiteid from deleted)
delete from tb_top100 where websiteid=(select websiteid from deleted)
IF (@@ERROR <> 0) -- 如果有错误
BEGIN
ROLLBACK TRANSACTION -- 回滚
END
COMMIT TRANSACTION -- 提交事务
- DELETE触发器
- Insert , Update , Delete 触发器
- delete触发器示例
- Oracle触发器之before delete
- 1, insert触发器; 2, update触发器; 3, delete触发器;
- 一个触发器内三种INSERT,UPDATE,DELETE状态
- SQL 表的Insert ,update ,delete 触发器
- 触发器 判断insert , update ,delete 的方法
- 创建INSERT、DELETE、UPDATE 触发器示例
- 单个触发器判断Insert/Delete/Update操
- sql触发器(insert,update,delete)
- sql触发器(insert,update,delete…
- 一个触发器内三种INSERT,UPDATE,DELETE状态
- 创建INSERT、DELETE、UPDATE 触发器示例 .
- SQL 通过触发器实现delete数据备份
- sql触发器(insert,update,delete)
- SQL触发器编程(insert/update/delete)
- 操作Ms Sql触发器的insert,update,delete
- 我收集的emule资源,希望对你能有帮助!!!
- GridView中的超链接
- 雷之歌
- dojo.data
- 最近比较生活较乱
- DELETE触发器
- 开发linux设备驱动程序并不是想象的那么难
- Series 60 2nd/3rd隐藏应用程序图标
- j2me手机开发入门
- sqlserver 2000中执行分布式事务的步骤
- Sqlserver2000中的事务处理
- MySQL-python安装测试
- WPF及silverlight 常用资源链接
- DataGrid中DropDownList触发SelectedIndexChanged事件并修改DataGrid行值