Posted by Roy Harvey on 06/27/07 18:56

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 <jkamaraj@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

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

[Reply to this message]