关于SQL触发器，请大家帮我看看那里错，一运行就死机

死神甜甜

CREATE trigger tr_fkpz on 付款凭证
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 付款凭证
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

死神甜甜

楼上你改了什么

fanfan1980

把 SET @NUM=@NUM+1 放在 while 外面,一運行就進入死循環

dream88

用这试试
CREATE trigger tr_fkpz on 付款凭证
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

死神甜甜

不是吧，我晕

fanfan1980

是的, 你暈吧