Posted by Raj on 06/27/07 19:47

On Jun 27, 11:56 am, Roy Harvey <roy_har...@snet.net> wrote:
> WAITFOR will do that.
>
> select getdate()
> waitfor delay '00:01:00'
> select getdate()
>
> Roy Harvey
> Beacon Falls, CT
>
>
>
> On Wed, 27 Jun 2007 11:16:26 -0700, Raj <jkama...@gmail.com> wrote:
> >Hell All,
> >To reproduce one of our cusotmer's probem, I need to make the SQL to
> >run for more than a minutes before it returns the result set. I do not
> >have large amount of data in the database to simulate the dealy.
>
> >Is there a way in SQL to cause the delay while returning the result
> >set
>
> >Thanks for the help.
>
> >Regards
> >Raj- Hide quoted text -
>
> - Show quoted text -

Thanks for replying. My challange is that I can pass only one SQL
statement at at time. Is there a function that I use like this:

select a, b, c
from table_a a, table_b where a.cid = b.cid and delay(0:0:1)

Thanks.
Raj

• Next in forum: Re: How to make a SQL run longer?
• Prev in forum: Re: How to reliably ensure that only one set of rows is bulk imported into a table at a time
• Thread view: Re: How to make a SQL run longer?

[Reply to this message]