触发器.sql

教材管理系统 asp设计本文主要介绍了基于JSP技术的电子商务动态网站

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