📄 示例4.sql

📁 SQL基础教程上的一些源码

💻 SQL

字号:

CREATE TRIGGER trForDelete 
ON BOOKS
FOR DELETE
AS
DECLARE @BOOKid INT
IF @@ROWCOUNT >0
BEGIN
SELECT @BOOKid=BOOKid from deleted 
DELETE BOOKRecord WHERE BOOKid=@BOOKid
END
GO

USE testTrigger
GO
DELETE BOOKS WHERE BOOKid=0
GO
SELECT * FROM BOOKS
GO
SELECT * FROM BOOKRecord
GO

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -