Basic While Loop example in T-SQL

Hi All,

Below is the sample while code snippet in T-SQL.

DECLARE @counter INT
SET @counter=10
WHILE @counter>=1
BEGIN
PRINT @counter
SET @counter = @counter-1
END
GO

Thanks,

Anilkumar