SQL to produce 1..100 as a comma separated string

WITH t AS (SELECT 1 id UNION ALL SELECT id + 1 FROM t WHERE id < 100)
SELECT STUFF((
         SELECT ', ' + CAST(id AS nvarchar(max))
         FROM (SELECT id FROM t) y
         FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '')