1DECLARE @var int -- Declare
2SELECT @var = 5 -- Initialization
3WHILE @var > 0 -- condition
4BEGIN -- Begin
5PRINT replicate('* ', @var) -- Print
6SET @var = @var - 1 -- decrement
7END -- END
8