MSSQL - Waitfor

There are ways to control the process time in MS SQL Server.

1.) Pause execution

waitfor delay ‘timestamp’
e.g. waitfor delay ’00:00:10′;


2) Specify time to execute

waitfor time ‘time’
e.g. waitfor time ’19:07:10′