How does one cause a delay in execution for a specified number of seconds?
This doesn't do it:
WAITFOR DELAY '00:02';
What is the correct format?
See Question&Answers more detail:osHow does one cause a delay in execution for a specified number of seconds?
This doesn't do it:
WAITFOR DELAY '00:02';
What is the correct format?
See Question&Answers more detail:osThe documentation for WAITFOR()
doesn't explicitly lay out the required string format.
This will wait for 2 seconds:
WAITFOR DELAY '00:00:02';
The format is hh:mi:ss.mmm
.