wait delay in sql server

The solution for this is noted below

wait delay in sql server

Solution

--The format is hh:mi:ss.mmm.
WAITFOR DELAY '00:00:02';

Try other methods by searching on the site. That is if this doesn’t work