示例6.sql

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

USE testTrigger
GO
INSERT BOOKS (BOOKid,BOOKName,BOOKNum)
VALUES(-1,'TEST BOOK',-1)
GO
SELECT * FROM BOOKS
GO

USE testTrigger
GO
DELETE BOOKS WHERE BOOKid =-1
GO
ALTER TABLE BOOKS
ADD CONSTRAINT chkBOOKidAndBOOKNum CHECK (BOOKid>=0 and BOOKNum>=0);
GO

USE testTrigger
GO
INSERT BOOKS (BOOKid,BOOKName,BOOKNum)
VALUES(-1,'TEST BOOK',-1)
GO
SELECT * FROM BOOKS
GO