第4章流程控制语句_循环结构第1次作业1. 编写程序,用Print语句显示1~50之间的奇数。
Declare @i int
Set @i = 1
While @i <= 50
Begin
Print @i
Set @i=@i+2
End
2. 求自然数1~100之间偶数之和。
Declare @s int, @i int
Set @s = 0
Set @i = 2
While @i <= 100
Begin
Set @s = @s + @i
Set @i = @i + 2
End
SELECT @s as 偶数和
3. 计算13+23+33+…+1003
Declare @i int, @s Bigint
Set @s=0
Set @i=1
While @i<=100
Begin
Set @s=@s+ power(@i,3)
Set @i=@i+1
End
Print @s
4. 计算10!
Declare @s Bigint, @i int
Set @s = 1
Set @i = 1
While @i<= 10
Begin
Set @s = @s * @i
Set @i = @i + 1
End
SELECT @s as 阶乘
5. 计算1!+2!+ (20)
Declare @s Bigint, @i int, @p Bigint
Set @s = 0
Set @p=1
Set @i = 1
While @i<= 20
Begin
Set @p = @p * @i
Set @s=@s+@p
Set @i = @i + 1
End
SELECT @s as 阶乘
6. 编写程序计算多项式11+22+33+…+1010
Declare @i Bigint, @s Bigint
Set @s=0
Set @i=1
While @i<=10
Begin
Set @s=@s+ power(@i,@i)
Set @i=@i+1
End
Print @s