9.1.1DML触发器创建 例9-1示例说明 inserted, deleted表 的作用。执行结果如右图。 rG,db-uery2.sq*要 程序清单如下: nsert into sc values( 313 c1,78 create table sc update sc set sno=3130030101 score= 89 where sno=3130030105' (sno char(10), cno char(2 score rea 结果息 Go 130078 CREATE TRIGGER tr1 ON SC FOR INSERT UP DATE DELETE AS □k m81 PRINT 'inserted表: Select* from inserted PRNT“ deleted表: 11313010c7 Select from deleted Go 图9-3触发器的执行结果 SQL SERVER2005入门与实例教程电子工业出版社20069.1.1 DML触发器创建 •例9-1 示例说明inserted，deleted表 的作用。执行结果如右图。 程序清单如下： create table sc (sno char(10), cno char(2), score real) Go CREATE TRIGGER tr1 ON sc FOR INSERT, UPDATE, DELETE AS PRINT ‘inserted表：’ Select * from inserted PRINT ‘deleted表：’ Select * from deleted Go 图9-3 触发器的执行结果