Posted by Erland Sommarskog on 06/27/07 21:33

Raj (jkamaraj@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• 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]