create trigger TR_S_update_age
on S
instead of update
as
select * into s2 from S
go
--测试触发器
update s set age=36 where sex='男'为什么在里面备份数据表用select * into s2 from S 不行,
而用insert into s2 select * from S 就可以
on S
instead of update
as
select * into s2 from S
go
--测试触发器
update s set age=36 where sex='男'为什么在里面备份数据表用select * into s2 from S 不行,
而用insert into s2 select * from S 就可以
再决定用insert into还是select into