关注对inserted的应用
create trigger [dbo].[trigger_dmployee]
on [dbo].[dmployee]
after insert
as
begin
declare @after_id int
declare @after_name char(50)
declare @after_sex char(2)
declare @after_age int
select @after_id=id from inserted
select @after_age=age from inserted
if @after_age<10
set @after_age=10
update dmployee
set age=@after_age
where id=@after_id
end