-- 九九乘法表 declare @i int,@j int declare @str varchar(max) set @i = 1 set @j = 1 while @i <= 9 begin set @j = 1 set @str = '' while @j <= @i begin set @str = @str + cast(@j as varchar)+'*'+cast(@i as varchar)+'='+cast(@i*@j as varchar)+' ' set @j = @j + 1 end print @str set @i = @i + 1 end 运行结果如下图所示: