Sleep

Table of Contents



Pauses the executing query for the given number of milliseconds. Useful for testing locking and timeouts.

Sleep(Numeric timeoutMilliseconds)

Permissions

Requires an account that is a member of an administrator role.


round-pushpin Waits for one second.
EXEC Sleep(1000)