Posted by Raj on 06/27/07 22:00

On Jun 27, 2:33 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Raj (jkama...@gmail.com) writes:
> > Thanks for replying. My challange is that I can pass only one SQL
> > statement at at time.
>
> Huh? What environment is this?
>
> > 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)
>
> You could write one that calls xp_cmdshell and the uses a wait command
> in the shell.
>
> But hopefullly you can also access the database from a regular query
> window. In such case you can start a transaction that locks one of the
> tables in your query. After a minute you commit/rollback that transaction,
> so that the other process is let go.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Thank you. I will try this and then update the thread.

• Next in forum: Re: How to make a SQL run longer?
• Prev in forum: Re: How to make a SQL run longer?
• Thread view: Re: How to make a SQL run longer?

[Reply to this message]