Script Results Only Rendered When Complete

I want to poll a row on a table:


DECLARE @CNT INT

DECLARE @Q NVARCHAR(1000)

SET @CNT = 1

WHILE(@CNT < 1000)

BEGIN

SET @Q = 'SELECT * FROM table'

PRINT @Q

EXEC sp_executesql @Q

SET @CNT = @CNT + 10

WAITFOR DELAY '00:00:01'

END




The thing is I want it just to run and run in a separate window, while something else is updating this table.

Thing is: it seems to run right to the end and only then produce output.

My question is: how can I get it to print output as it happens, rather than when the script is complete?