求帮我改个插入行的触发器,flag都是1，没变化

[wangoct]

求帮我改个插入行的触发器 ，有重复名字FLAG=2 , 3 4 5

ALTER TRIGGER [dbo].[charu4]
ON [dbo].[gongzuoliang]
AFTER INSERT
AS
BEGIN
declare @ID int
declare @teachername nvarchar
declare @flag float
declare @zongkeshi float
declare @zks float

declare cur_Insert cursor
for
select ID,teachername, flag ,zongkeshi,zks from inserted
open cur_Insert
fetch next from cur_Insert into @ID ,@teachername,@flag,@zongkeshi,@zks
while @@fetch_status=0
begin
set @flag=(select count(*) from [dbo].[gongzuoliang] where teachername=@teachername)

update [dbo].[gongzuoliang]
set flag=@flag where id=@id

fetch next from cur_Insert into @ID ,@teachername,@flag,@zongkeshi,@zks
end
close cur_Insert
deallocate cur_Insert
END

[不断学习的ITer]

为什么要用游标么？新增哪行，就取得哪行数据更新就行了

[wangoct]

我是将另一个表，查询的数据，从而插入进来本表

[不断学习的ITer]

ALTER TRIGGER Test ON [dbo].[gongzuoliang] AFTER INSERT AS declare @count int set @count=0; BEGIN select @count=count(1) from insertedtest where teachername= (select teachername from inserted) update dbo.gongzuoliang set flag =@count where teachername=(select teachername from inserted) END ---- 你这个只要处理当前行就可以了，没必要每次处理所有行