SQLServer 中触发器使用的问题
野生大猫 2011-01-05 02:20:31 create trigger t_flag on zhuangtaibiaozhi for update
as
declare @flag varchar(20),@id int
select @flag='最新修改'
print @flag
update zhuangtaibiaozhi set flag =@flag from zhuangtaibiaozhi z,deleted d where z.id_identity = d.id_identity
select @id = id_identity from zhuangtaibiaozhi where flag = '最新修改'
print @id
update zhuangtaibiaozhi set flag='' where id_identity <> @id
go
测试
update zhuangtaibiaozhi set xgsbdqzt=0 where xgsbbh=1 and sbdid=1
update zhuangtaibiaozhi set xgsbdqzt=0 where xgsbbh=1 and sbdid=3
结果
最新修改
(所影响的行数为 1 行)
10
(所影响的行数为 1 行)
执行2次更新 结果一致 为什么变量@id 不改变呢?