02_counter.sql

-- Declare the variable (a SQL Command, the var name, the datatype)
DECLARE @counter INT;
-- Set the counter to 20
SET @counter = 20;

-- Print the initial value
SELECT @counter AS _COUNT;

-- Select and increment the counter by one
SELECT @counter = @counter + 1;

-- Print variable
SELECT @counter AS _COUNT;

-- Select and increment the counter by one
SELECT @counter += 1;

-- Print the variable
SELECT @counter AS _COUNT;