sqlserver实现各种乘法表

--1.乘法表左上
declare @a int,@b int,@c varchar(max)
set @a=1
set @c=''
while @a<=9
begin
set @b=1
	while @b<=(10-@a)
		begin
		set @c=@c+cast(@a as varchar(1))+'*'+ cast(@b as varchar(1)) +'='+left(cast(@a*@b as varchar(2))+'  ',3)
		set @b=@b+1
	end
print @c
set @c=''
set @a=@a+1
end

--2.乘法表左下
declare @a int,@b int,@c varchar(max)
set @a=1
set @c=''
while @a<=9
begin
set @b=1
	while @b<=@a
		begin
		set @c=@c+cast(@a as varchar(1))+'*'+ cast(@b as varchar(1)) +'='+left(cast(@a*@b as varchar(2))+'  ',3)
		set @b=@b+1
	end
print @c
set @c=''
set @a=@a+1
end

--3