如何为触发器赋值
求教啊 如何为触发器赋值
[解决办法]
ALTER TRIGGER T_CourseSchedule_UpdateFlag
ON T_CourseSchedule
AFTER UPDATE
AS
DECLARE @courseID int,@oldflag int,@newFlag int
IF UPDATE([flag])
BEGIN
SELECT @oldflag=flag from inserted
SELECT @newFlag=flag from inserted
SELECT @courseID=courseID FROM inserted
UPDATE T_SelectQuestionBank SET flag=@newFlag where courseID=@courseID
--UPDATE T_SelectQuestionBank SET flag=0
END
GO
UPDATE T_CourseSchedule SET flag=1 WHERE courseID=5
