In T-SQL control statements, you can use the WAITFOR command to delay the execution of a T-SQL batch statement block, stored procedure, or transaction. When you specify the DELAY keyword, the execution is delayed for a given amount of time up to a maximum of 24 hours.
WAIT FOR DELAY ''00:01:00''
Alternatively, you can specify the TIME keyword to delay the batch execution until a specified system time.
WAITFOR TIME '23:00'
Remember that after executing the WAITFOR statement, you cannot use your connection to SQL Server until the time or event that you specified occurs.