delay seconds sql server code example

Example: wait delay in sql server

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