sql server query execution waiting time set

Sql server Execution the script for specified period of time say 1 hours or 5minutes or 5seconds or
millisecond etc we can use the WAITFOR DELAY command.

SYNTAX
WAITFOR DELAY '00:00:00.000'
Example:
WAIT for 05 Sec
select * from country
WAITFOR DELAY '00:00:05.000'

Post a Comment

0 Comments