SQL Server query that takes time

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 leve开发者_运维技巧l its ok . How can I do this?

Use the WAITFOR command:

WAITFOR DELAY '00:00:05';