SqlServer update触发器 inserted临时表的有关问题
SqlServer update触发器 inserted临时表的问题
sql语句
触发
------解决方案--------------------
ALTER TRIGGER triggerA
ON tableA
FOR update
AS
begin
declare @tmp int
select @tmp = id from inserted
end
sql语句
- SQL code
update tableA set age=11 where id=100;
触发
- SQL code
ALTER TRIGGER triggerA ON tableA FOR update(age) AS declare @tmp int set @tmp=(select top 1 id from inserted) //tmp的值没变化 //在inserted 和deleted临时表中貌似只有age的值 //这个地方如何取到tableA.id 的值?
------解决方案--------------------
ALTER TRIGGER triggerA
ON tableA
FOR update
AS
begin
declare @tmp int
select @tmp = id from inserted
end