SQL Server query that takes time

Question

For a recent test, I want to 'create' a query which takes atleast 5 seconds to execute and does not change the schema or data of the database - although I can create a table and then delete it. Till that level its ok . How can I do this?

http://stackoverflow.com/questions/664902/sleep-command-in-t-sql — Sam Saffron, Sep 04 '10 at 02:36

score 1 · Accepted Answer · answered Sep 04 '10 at 02:31

1

Use the WAITFOR command:

WAITFOR DELAY '00:00:05';

answered Sep 04 '10 at 02:31

Dave Markle

95,573
20
147
170

any quick query that you can think of to run with the command? – ScG Sep 04 '10 at 02:52
Not sure what you're asking. If you just want output, you could do something like "SELECT 1 AS Test;" – Dave Markle Sep 04 '10 at 02:54

SQL Server query that takes time

1 Answers1