Subject | DELAY OR WAIT |
---|---|
Author | Adomas Urbanavicius |
Post date | 2004-12-11T12:48:25Z |
Hi,
Are there any supported functions in SQL to do
command delay :
delay(msec)
or
wait(msec) ?
lets say is system service stored proc :
while not (exists (select * blah blah)) do
begin
delay(1500);
end
If I run such statement without delay it would consume all CPU.
Adomas
Are there any supported functions in SQL to do
command delay :
delay(msec)
or
wait(msec) ?
lets say is system service stored proc :
while not (exists (select * blah blah)) do
begin
delay(1500);
end
If I run such statement without delay it would consume all CPU.
Adomas