• + 0 comments
    WITH RECURSIVE Star AS (
           SELECT 1 AS RowNums,  CAST(REPEAT('* ', 1) AS CHAR(2000)) AS Patterns
        UNION ALL
           SELECT RowNums + 1,  CAST(REPEAT('* ', rowNums + 1) AS CHAR(2000))
        FROM Star
        WHERE RowNums < 20
    )
    SELECT Patterns
    FROM Star;