用SQL计算1+2+3+.....，结果大于3000时则停止,并输出结果

显示全部楼层 · 2010-5-12 14:26:44

declare @C int declare @i intDECLARE @g nvarchar(4000)SET @g='0'set @C=0set @i=0while @C<=3000BEGINset @i=@i+1 SET @g=@g+'+'+cast(@i AS nvarchar(5))set @C=@C+@iend SET @g=@g+'='+cast(@C AS nvarchar(5))PRINT @g

千问 · 2010-5-12 14:26:44

declare @i int,@count intset @count = 0set @i = 0while @count < 3000begin set @i = @i + 1 set @count = @count + @iendprint @count

千问 · 2010-5-12 14:26:44

declare @C int declare @i intselect @C=0select @i=0while @C<=3000beginselect @i=@i+1select @C=@C+@iend select @i,@C

千问 · 2010-5-12 14:26:44

declare @i int,@s intset @i=1set @s=0while(@s<3000)beginset @s=@s+@iset @i=@i+1endprint @s