sql一条update指令只会触发一次触发器的解决方案

使用游标即可解决

 

create trigger testTrigger
on TableName
for update
as
 
begin
 
declare youbiao CURSOR  /*声明游标*/
for 
	select ID1,name from inserted
	open youbiao
	
	declare @ID1 int,@name varchar(20)
	fetch next from youbiao into @ID1,@name/*读取第一条数据*/
	while(@@fetch_status=0) /*表示成功执行fetch语句*/
	begin
	     --做你要做的事情 
	fetch next from youbiao into @ID1,@name /*游标下移*/
	end
close youbiao 
deallocate youbiao 
end