插入触发器
inserted.属性 直接写不行,我也不知道为什么 |·_·)
我想到的方法,可以插入一个唯一值后再进行修改
create trigger insert_em_insert_xs
on Employee
after insert
as
begin
insert into Xs values('qwe','01',5000)
update Xs set employeeid=(select employeeid from inserted) where employeeid='qwe'
end
应该是正经的方法,要先定义变量,通过select把inserted表里的值取出来才能用
create trigger insert_em_insert_xs
on Employee
after insert
as
begin
declare @id char(20)
select @id=employeeid from inserted
insert into Xs values(@id,'01',5000)
end