第05章-数据库完整性资料.pptVIP

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * An Introduction to Database System Microsoft SQL Server 触发器示例 例2：创建一个触发器监视insert操作，若插入的记录中版权费超过30，则提示用户，并回滚此操作。 use pubs go ? if exists(select name from sysobjects where name =CheckRoyalty and type=tr) drop trigger CheckRoyalty go An Introduction to Database System Microsoft SQL Server 触发器示例 create trigger checkroyalty on roysched for insert as if (select royalty from inserted) 30 begin print royaltytrigger：版权费不能超过 30 print 请将版