总是没法退出循环

[南瓜饼]

declare @TID int,@UID int,@RID int
select @UID=UID from bbsUsers where Uname='心酸果冻'
select @TID=TID from bbsTopic 
		where Ttopic='什么是.net啊'and Tcontents='微软的广告快超过半个北京城了' and TuID=@UID
select @RID=RID from bbsReply
		where RtID=@TID
--回帖人-50分
while(1=1)
	begin
		if exists(select top 1 RuID from bbsReply where RtID=@TID)
			begin
			select top 1 @UID=RuID from bbsReply where RtID=@TID
			update bbsUsers set Upoint =Upoint-50 where UID=@UID
			--删除回帖表
			delete from bbsReply where RID=@RID
			end
		else
			break
	end

[南瓜饼]

会一直执行 不是有break吗

[fengyun142415]

满足条件才会break

[wpeng8218]

exists(select top 1 RuID from bbsReply where RtID=@TID)

这个条件一直成立，无法运行到break;

[dawugui]

因为你一直存在:

if exists(select top 1 RuID from bbsReply where RtID=@TID)

而你的删除语句是:

delete from bbsReply where RID=@RID

注意:一个是RtID=@TID,一个是RID=@RID.

[wpeng8218]

把这句delete from bbsReply where RID=@RID修改成
delete from bbsReply where RtID=@TID

就能执行到break;

[yangzh8343]

当条件成立后加入break;