示例8.sql

SQL基础教程上的一些源码

USE testTrigger
GO

EXEC sp_bindrule 'rBookid', 'dbo.BOOKS.BOOKid'
EXEC sp_bindrule 'rBookNum', 'dbo.BOOKS.BOOKNum'
GO

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