How to Print Star Triangle in SQL Using CTE

Gaurav Gangwar

10y7.6kCode

This code snippet for Print Pattern triangle in SQL.

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