示例4.sql

来自「SQL基础教程上的一些源码」· SQL 代码 · 共 20 行

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