怎么计算从1加到10并且显示总和。如:
declare @sum int,@n int
set @sum=0
set @n=0
while @n<=10
begin
@sum=@sum+@n
@n=@++
end
print '1+2+3+.......10'=
这样程序为什么会出现end附近出现错误,‘=’附件出现错误
我是一个菜鸟,请各位高手指点
declare @sum int,@n int
set @sum=0
set @n=0
while @n<=10
begin
@sum=@sum+@n
@n=@++
end
print '1+2+3+.......10'=
这样程序为什么会出现end附近出现错误,‘=’附件出现错误
我是一个菜鸟,请各位高手指点
set @sum=0
set @n=0
while @n <=10
begin
SET @sum=@sum+@n
SET @n=@++
end
PRINT @sum
set @sum=0
set @n=0
while @n <=10
begin
set @sum=@sum+@n
set @n=@n+1
end
print '1+2+3+.......10='+rtrim(@sum)
/*
1+2+3+.......10=55
*/
set @sum=0
set @n=0
while @n <=10
begin
SET @sum=@sum+@n
SET @n=@N++
end
PRINT @sum
set @sum=0
set @n=0
while @n <=10
begin
set @sum=@sum+@n
set @n=@n+1
end print @sum
set @sum=0
set @n=0
while @n <=10
begin
SET @sum=@sum+@n
SET @n=@N+1
end
PRINT @sum弄得老跟程序中一样了
set @sum=0
set @n=0
while @n <=10
begin
set @sum=@sum+@n
set @n=@n+1
end
print '1+2+3+.......10='+ltrim(@sum
set @sum=0
set @n=0
while @n <=10
begin
set @sum=@sum+@n
set @n=@n+1
end print '1+2+...+10='+ltrim(@sum)
JAVA也这样。。
里可以有 @n++ 这样的写法?
from (
select top 10 row_number() over(order by object_id) as id, * from sys.objects
) tb
declare @sum int,@n int
set @sum=0
set @n=0
while @n <=10
begin
@sum=@sum+@n
@n=@++
end
print @sum