fizzbuzz tsql

gistfile1.sql

IF OBJECT_ID ( 'dbo.fb', 'P' ) IS NOT NULL 
  drop procedure dbo.fb;

GO

CREATE PROCEDURE dbo.fb (@int int)
AS
	
	set @int = @int + 1
	
	select @int,
		case
			when (@int % 3 = 0) then 'fizz' --'fizz'
			when (@int % 5 = 0) then 'buzz' --'buzz'
		else cast(@int as char)
	end

	execute dbo.fb @int
	
GO

execute dbo.fb 1