FizzBuzz_ThreeLoops.sql

--While_Loop
DECLARE @counter INT
DECLARE @output VARCHAR(max)=''
SET @counter = 1
WHILE @counter < 101
BEGIN
SELECT @output+= 
CASE WHEN @counter % 15 = 0 THEN 'FizzBuzz'
WHEN @counter % 5 = 0 THEN 'Buzz'
WHEN @counter % 3 = 0 THEN 'Fizz'
ELSE CAST(@counter AS VARCHAR(8)) 
END + char(9)+char(10)
SET @counter = @counter + 1
END
 
Print @output

 
 
 
 
 ---- DO_WHILE
DECLARE @counter INT
DECLARE @output VARCHAR(max)=''
SET @counter = 1
BEGIN

Starting:

SELECT @output+= 
CASE WHEN @counter % 15 = 0 THEN 'FizzBuzz'
WHEN @counter % 5 = 0 THEN 'Buzz'
WHEN @counter % 3 = 0 THEN 'Fizz'
ELSE CAST(@counter AS VARCHAR(8)) 
END + char(9)+char(10)
  
SET @counter += 1

IF @counter <=100  
GOTO Starting ;

 Print @output

END


 ---- REPEAT_UNTIL
DECLARE @counter INT
DECLARE @output VARCHAR(max)=''
SET @counter = 1
BEGIN
Starting:

SELECT @output+= 
CASE WHEN @counter % 15 = 0 THEN 'FizzBuzz'
WHEN @counter % 5 = 0 THEN 'Buzz'
WHEN @counter % 3 = 0 THEN 'Fizz'
ELSE CAST(@counter AS VARCHAR(8)) 
END + char(9)+char(10)
SET @counter = @counter + 1

IF NOT(@counter >100) 
GOTO Starting ;
 
END

Print @output