An implementation of FizzBuzz in T-SQL

FizzBuzz.sql

with t as (select 1 x union all select x + 1 from t where x < 100)
select case
  	when x % 3 = 0 AND x % 5 = 0 then 'FizzBuzz'
		when x % 3 = 0 then 'Fizz'
		when x % 5 = 0 then 'Buzz'
		else CAST(x as varchar)
	end
from t