SQL版的九九乘法表

-- 九九乘法表declare @i int,@j intdeclare @str varchar(max)set @i = 1set @j = 1while @i <= 9beginset @j = 1set @str = ''while @j <= @i beginset @str = @str + cast(@j as varchar)+'*'+cast(@i as varchar)+'='+cast(@i*@j as varchar)+' 'set @j = @j + 1 endprint @str set @i = @i + 1end

 

 

 

运行结果如下图所示：