Regarding SQL triggers, please help me see where there is a mistake, as soon as it runs

死神甜甜

CREATE trigger tr_fkpz on payment document
for insert
as
declare @CusName VARCHAR (100),
        @Mname varchar (100),
        @GradeName varchar (100),
        @Jweight decimal,
        @ID char (15),
        @NUM int,
        @count int
select @ count = count (*) from ls
set @ NUM = 1
while @NUM <@ count + 1
begin
select @ ID = ID from ls where NUM = @ NUM
uPDATE App_Ponderation SET YS = 1 where IDcode = @ ID
end
SET @ NUM = @ NUM + 1

fanfan1980

CREATE trigger tr_fkpz on payment voucher
for insert
as
declare @CusName VARCHAR(100),
        @Mname varchar(100),
        @GradeName varchar(100),
        @Jweight decimal,
        @ID char(15),
        @NUM int,
        @count int
select @count=count(*) from ls
set @NUM=1
while @NUM<@count+1
begin
select @ID=ID from ls where NUM=@NUM
uPDATE App_Ponderation SET YS=1 where IDcode=@ID
SET @NUM=@NUM+1
end

死神甜甜

What did you change upstairs

fanfan1980

Put SET @NUM=@NUM+1 outside of while, and enter an infinite loop as soon as it runs

dream88

Try it with
CREATE trigger tr_fkpz on payment voucher
for insert
as
declare @CusName VARCHAR(100),
        @Mname varchar(100),
        @GradeName varchar(100),
        @Jweight decimal,
        @ID char(15),
        @NUM int,
        @count int
select @count=count(*) from ls
set @NUM=1
while @NUM<@count+1
begin
select @ID=ID from ls where NUM=@NUM
uPDATE App_Ponderation SET YS=1 where IDcode=@ID
SET @NUM=@NUM+1

end

死神甜甜

No, i'm dizzy

fanfan1980

Yes you dizzy