第12章 触发器_简.pdfVIP

12 12.1 12.1.1 1 2 3 4 12.1.2 SQL Server 2008 DML DDL SQL Server 2008 DML DDL DML 1DML DML (DML)DML UPDATEINSERT DELETE 1 AFTER INSERT UPDATE DELETE T-SQL 2 INSTEAD OF INSERTUPDATE DELETE T-SQL 2DDL DDL SQL Server 2008 (DDL) 3. SQL Server 12.1.3 SQL Server 2008 INSERTED DELETED 1 INSERTED 2 DELETED 3DELETE INSERT DELECTED INSERTED INSERTED DELETED 12.2 DML 12.2.1 DML 1 CREATE TRIGGER ON { |} [WITH ENCRYPTION] {FOR|AFTER|INSTEAD OF} {[INSERT][,UPDATE][,DELETE]} [WITH APPEND] [NOT FOR REPLICATION] AS [BEGIN] SQL | [END] 2 1 SQL Server 2008 2 | 3WITH ENCRYPTION 4FOR|AFTER|INSTEAD OF FOR|AFTER INSTEAD OF 5[INSERT][,UPDATE][,DELETE] INSERT UPDATE DELETE 6WITH APPENDINSTEAD OF 7NOT FOR REPLICATIONDBMS 8SQL | IF UPDATE()[AND|OR UPDATE()[,n ]] [BEGIN] SQL | [END] IF AND OR 9 DML ALTER DATABASECREATE DATABASEDROP DATABASELOAD DATABASELOAD LOGRECONFIGURERESTORE DATABASERESTORE LOG T-SQL 3 1 12-1 tgInsClass class XXX! XXX CREATE TRIGGER tgInsClass ON class FOR INSERT -- AS BEGIN SELECT +! FROM INSERTED END 12-2 class 13-12013 12-1 tgInsClass 12-1 INSERT INT