共同變數宣告
DECLARE @I INT, @J INT, @S VARCHAR(200);
1. 左下角直角三角形
SET @I = 1;
WHILE @I < 10 BEGIN
SET @J = 1; SET @S = '';
WHILE @J <= @I BEGIN
SET @S = @S + CAST(@J AS CHAR(1)) + '*' + CAST(@I AS CHAR(1)) + '=' + CAST((@I*@J) AS CHAR(3)) + ' ';
SET @J = @J + 1;
END
PRINT @S;
SET @I = @I + 1;
END

2. 右下角直角三角形
SET @I = 1;
WHILE @I < 10 BEGIN
SET @J = 9; SET @S = '';
WHILE @J > 0 BEGIN
IF @J > @I SET @S = @S + ' '; -- 7 空格對齊
ELSE SET @S = @S + CAST(@I AS CHAR(1)) + '*' + CAST(@J AS CHAR(1)) + '=' + CAST((@I*@J) AS CHAR(3)) + ' ';
SET @J = @J - 1;
END
PRINT @S;
SET @I = @I + 1;
END

3. 右上角直角三角形
SET @I = 1;
WHILE @I < 10 BEGIN
SET @J = 1; SET @S = '';
WHILE @J < 10 BEGIN
IF @J < @I SET @S = @S + ' ';
ELSE SET @S = @S + CAST(@I AS CHAR(1)) + '*' + CAST(@J AS CHAR(1)) + '=' + CAST((@I*@J) AS CHAR(3)) + ' ';
SET @J = @J + 1;
END
PRINT @S;
SET @I = @I + 1;
END

4. 左上角直角三角形
SET @I = 1;
WHILE @I < 10 BEGIN
SET @J = @I; SET @S = '';
WHILE @J < 10 BEGIN
SET @S = @S + CAST(@I AS CHAR(1)) + '*' + CAST(@J AS CHAR(1)) + '=' + CAST((@I*@J) AS CHAR(3)) + ' ';
SET @J = @J + 1;
END
PRINT @S;
SET @I = @I + 1;
END

教學重點
- 熟悉
WHILE 迴圈、字串拼接、CAST 型別轉換、條件判斷與 PRINT 輸出。
- 空格對齊技巧:固定寬度字元或
REPLICATE(' ', n)。
- 實務上較少直接在 T-SQL 產生報表格式,通常由應用層處理呈現。