触发器

//触发器Create Table Student(              --学生表         StudentID int primary key,       --学号        )       Create Table BorrowRecord(               --学生借书记录表         BorrowRecord   int identity(1,1),       --流水号           StudentID      int ,                    --学号         BorrowDate     datetime,                --借出时间         ReturnDAte     Datetime,                --归还时间       )   Create Trigger truStudent        On Student                         --在Student表中创建触发器        for Update                          --为什么事件触发      As                                        --事件触发后所要做的事情        if Update(StudentID)                   begin          Update BorrowRecord            Set StudentID=i.StudentID            From BorrowRecord br , Deleted   d ,Inserted i      --Deleted和Inserted临时表            Where br.StudentID=d.StudentID        end      //触发器回滚事务create trigger orderinserton ordersafter insertas if (select status from goods,insertedwhere goods.name=inserted.goodsname)=1beginprint 'the goods is being processed'print 'the order cannot be committed'rollback transaction   --回滚﹐避免加入end