示例8.sql

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

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