引题:把员工表中将要退休的员工信息删除一条,同时把该信息存入退休员工表中。这时就要用到触发器
-------------------------------------------------------------------------------
reate trigger oldEmp on employee
AFTER delete
insert into oldemployee
as
insert into oldemployee select * from deleted
go
---------------------------------------------------------------------------------
1、关于selected ,deleted
2、