loop in sql

DECLARE @Counter INT 
SET @Counter=1
WHILE ( @Counter <= 100)
BEGIN
    PRINT 'The counter value is = ' + CONVERT(VARCHAR,@Counter)
		SET @Counter  = @Counter  + 1
END