WITH PrintStar(STATEMENT, LENGTH)
AS(SELECT STATEMENT = CAST('*'
AS VARCHAR(10)), LEN('*') UNION ALL SELECT CAST(STATEMENT + '*'
AS VARCHAR(10)), LEN(STATEMENT) FROM PrintStar WHERE LENGTH < 9)
SELECT STATEMENT FROM PrintStar
How to Print Star Triangle in SQL Using CTE
This code snippet for Print Pattern triangle in SQL.