萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 資料庫 >> MS SQL 資料庫

T-SQL 實作四種九九乘法表圖形輸出

共同變數宣告

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 產生報表格式,通常由應用層處理呈現。
copyright © 萬盛學電腦網 all rights reserved