sql语句update tableA set age=11 where id=100;
触发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(age)
AS
declare @tmp int
set @tmp=(select top 1 id from inserted)
//tmp的值没变化
//在inserted 和deleted临时表中貌似只有age的值
//这个地方如何取到tableA.id 的值?
ON tableA
FOR update
AS
begin
declare @tmp int
select @tmp = id from inserted
end
ON tableA FOR update
AS
IF UPDATE(age)
BEGIN
declare @tmp int
set @tmp=(select top 1 id from inserted)
END