Question

SQL使用while语句怎么求1到100之间的累加和并输出？

Answer 1

main()
{
int i,sum=0;
for(i=1;i<=100;i++)
if(i%2==1) sum+=i;
printf("%d\n",sum);
i=1;
sum=0;
while(i<=100)
{
if(i%2==1) sum+=i;
i++;
}
printf("%d\n",sum);
}

DECLARE @sum int , @i int
SET @sum = 1
SET @i = 1
WHILE @i<=10
BEGIN
SET @sum = @sum+ @i
SET @i = @i + 1
END
PRINT @sum