James-McNeill/03_while_loop.sql

## 03_while_loop.sql
-- Declare the initial value
DECLARE @counter INT;
SET @counter = 20;

-- Print initial value
SELECT @counter AS _COUNT;

-- Create a loop
BEGIN;
-- Loop code starting point
WHILE @counter < 30
	SELECT @counter = @counter + 1;
-- Loop finish
END;

-- Check the value of the variable
SELECT @counter AS _COUNT;
	-- Declare the initial value
	DECLARE @counter INT;
	SET @counter = 20;

	-- Print initial value
	SELECT @counter AS _COUNT;

	-- Create a loop
	BEGIN;
	-- Loop code starting point
	WHILE @counter < 30
	SELECT @counter = @counter + 1;
	-- Loop finish
	END;

	-- Check the value of the variable
	SELECT @counter AS _COUNT;