Problems with WHILE and PRINT

[lindawie]

Jeff,

> I am trying to get a WHILE loop to print status messages to Query
> Analyzer as I run the following query on SQL2K SP3:
>
> Additionally, if I halt execution midway, there is no output.
> How can I actually get a message to appear to the screen every 5
> seconds?

Use raiserror() with the nowait option and severity 0 for
informational message.

declare @untilTime datetime
declare @Now varchar(30)

SET @untilTime = DATEADD(second, 30, getdate())
while getdate() < @untilTime begin
waitfor delay '00:00:05.000'
set @Now = convert(varchar(30), getdate(), 121)
raiserror ('%s', 0, 1, @Now) with nowait
end

Linda

[Jeff Albenberg]

Thanks. Works just like I need.


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!