22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER Insert2_Or_Update_sal ON Teacher1
FOR UPDATE
AS
BEGIN
DECLARE @Sal NUMERIC(7, 2) ,
@Job VARCHAR(15) ,
@Tno VARCHAR(15) ,
@Sal0 NUMERIC(7, 2) ,
@Job0 VARCHAR(15) ,
@Tno0 VARCHAR(15)
DECLARE @msg CHAR(50)
SELECT @Tno = Tno ,
@Job = Job ,
@Sal = Sal
FROM Inserted
SELECT @Tno0 = Tno ,
@Job0 = Job ,
@Sal0 = Sal
FROM Deleted
IF ABS(@Sal - @Sal0) > 2000
SET @msg = '插入后的薪资比插入前的薪资变动过大,故将为您取消此插入操作!'
PRINT @msg
ROLLBACK TRANSACTION
END