Sql Server数据库小组 / 不需要表的递归cte的小例子

with MyCTE(x) as(
 select x = convert(varchar(8000),'hello')
 union all
 select x + 'a' from MyCTE where len(x) < 100
)
select x from MyCTE order by x