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?

Answer 1

Use the WAITFOR command:

WAITFOR DELAY '00:00:05';