触发器.sql

来自「是一个教材管理系统」· SQL 代码 · 共 12 行

use BookManager
GO
CREATE TRIGGER CHOOSE
on tblClassChsBook
INSTEAD OF insert
as 
DECLARE @TakenNum int,@TrueTaken int,@BookId int ,@ClassId int
select @TakenNum=s.TakenNum,@TrueTaken=s.TrueTaken ,@BookId=s.BookId ,@ClassId=s.ClassId from inserted as s
	IF  Exists(select *  from tblClassChsBook as s ,inserted  where s.BookId=inserted.BookId and s.ClassId=inserted.ClassId)
          update tblClassChsBook set tblClassChsBook.TakenNum=tblClassChsBook.TakenNum+@TakenNum , tblClassChsBook.TrueTaken=tblClassChsBook.TrueTaken+@TrueTaken
			where tblClassChsBook.BookId=@BookId and tblClassChsBook.ClassId=@ClassId