sql server 数据库打印99乘法表-计算1-到100的和-函数

-------------  sql server 打印乘法口诀表

declare @x int

set @x=1

declare @y int

declare @c varchar(8000)

while(@x<=9)

begin

 select @y=1,@c=''

 while(@y<=@x)

 begin

   select @c=@c+cast(@y as varchar)+'*'+cast(@x as varchar)+'='+cast(@x*@y as varchar)+' '

   set @y=@y+1

 end

 print @c+char(10)

 set @x=@x+1

end

------------- sql server 计算1-100的和 

declare @a int

declare @sum int

set @a=1

set @sum=0

while @a<=100

begin

set @sum+=@a

set @a+=1

end

print @sum