SQL Server TSQL Loop example

tsql_loop.sql

DECLARE @cnt INT = 0;

WHILE @cnt < 10
BEGIN
	PRINT 'Doing Something in loop #' + Convert(VARCHAR(10),@cnt);
	--Use RAISEERROR to flush PRINT buffer
	RAISERROR(N'', --message 
		  0, --severity
		  1) --state
		  WITH NOWAIT;
	WAITFOR DELAY '00:00:01';
	SET @cnt = @cnt + 1;
END;