Count down from 0 to 5 seconds and repeat What query can I use to trigger a count down from 0 to 5 seconds whenever executed? When I execute a query the output has to be 0 second to 5 second and once 5 seconds are done again it should go back to 0. When I execute again it should start from 0 to 5 seconds. Is it possible to achieve something like this using sql query?
WaitFor should help you accomplish this.

In your case we can simply pass a DELAY time as below

WAITFOR DELAY '00:00:05';


This will simply wait for 5 seconds, then return to the caller.