• + 0 comments

    FOR SQL SERVER with starpattern as ( select 20 as num union all select num -1 from starpattern where num>1 ) select replicate('* ',num)as stars from starpattern option(maxrecursion 0);