代码书写:
-- 循环输出九九乘法表
DECLARE @i int = 1, @j int , @s varchar(100)
WHILE @i < = 9
begin
SET @j = 1;
SET @s = ''; -- 循环接收乘法表达式
WHILE @j <= @i
begin
SET @s += CONVERT(varchar(10), @j) + ' * ' + CONVERT(varchar(10), @i) + ' = ' + CONVERT(varchar(10), @i * @j) + SPACE(1);
SET @j += 1;
end
PRINT @s;
SET @i += 1;
end
运行示例: