创建触发器.sql

来自「SQL数据库的一些基本的操作源码 包括创建存储过程,表,触发器的创建」· SQL 代码 · 共 31 行

use mydb
go
create trigger newemp on employees
after insert 
as 
if(select salary from inserted)>1000
begin 
 print '新员工工资不能超过1000'
 rollback
end
go

use mydb
go
create trigger changemp on employees
 after update
 as
if(update (salary) ) 
begin
  if(select max(ABS(inserted.salary-deleted.salary)) from inserted join deleted on inserted.empid=deleted.empid )>1500
  begin
     print '员工工资变动不能超过1500'
     rollback
  end
end
go


--测试
update employees set salary=salary+4000
where empid=0001