sqlserver实现各种乘法表

--1.乘法表左上declare @a int,@b int,@c varchar(max)set @a=1set @c=''while @a<=9beginset @b=1while @b<=(10-@a)beginset @c=@c+cast(@a as varchar(1))+'*'+ cast(@b as varchar(1)) +'='+left(cast(@a*@b as varchar(2))+'  ',3)set @b=@b+1endprint @cset @c=''set @a=@a+1end--2.乘法表左下declare @a int,@b int,@c varchar(max)set @a=1set @c=''while @a<=9beginset @b=1while @b<=@abeginset @c=@c+cast(@a as varchar(1))+'*'+ cast(@b as varchar(1)) +'='+left(cast(@a*@b as varchar(2))+'  ',3)set @b=@b+1endprint @cset @c=''set @a=@a+1end--3.乘法表右上declare @a int,@b int,@c varchar(max)set @a=1set @c=''while @a<=9beginset @b=1while @b<=9beginif @a>@bset @c=@c+'       'elseset @c=@c+cast(@a as varchar(1))+'*'+ cast(@b as varchar(1)) +'='+left(cast(@a*@b as varchar(2))+'  ',3)set @b=@b+1endprint @cset @c=''set @a=@a+1end--4.乘法表右下declare @a int,@b int,@c varchar(max)set @a=1set @c=''while @a<=9beginset @b=1while @b<=9beginif (@a+@b)<10set @c=@c+'       'elseset @c=@c+cast(@a as varchar(1))+'*'+ cast(@b as varchar(1)) +'='+left(cast(@a*@b as varchar(2))+'  ',3)set @b=@b+1endprint @cset @c=''set @a=@a+1end--5.乘法表菱形内空declare @a int,@b int,@c varchar(max)set @a=1set @c=''while @a<=9beginset @b=1while @b<=9beginif @a<=5 and @b>(5-@a) and @b<(5+@a)set @c=@c+'       'else if @a>5 and @b>(@a-5) and @b<(15-@a)set @c=@c+'       'elseset @c=@c+cast(@a as varchar(1))+'*'+ cast(@b as varchar(1)) +'='+left(cast(@a*@b as varchar(2))+'  ',3)set @b=@b+1    endprint @cset @c=''set @a=@a+1end--6.乘法表菱形外空declare @a int,@b int,@c varchar(max)set @a=1set @c=''while @a<=9beginset @b=1while @b<=9beginif @a<=5 and (@b<=(5-@a) or @b>=(5+@a))set @c=@c+'       'else if @a>5 and (@b<=(@a-5) or @b>=(15-@a))set @c=@c+'       'elseset @c=@c+cast(@a as varchar(1))+'*'+ cast(@b as varchar(1)) +'='+left(cast(@a*@b as varchar(2))+'  ',3)set @b=@b+1    endprint @cset @c=''set @a=@a+1end