1. 类似C语言中的"sleep"语法:WAITFOR DELAY
--wait for 1s
WAITFOR DELAY '00:00:01:000'
--wait for 1min
WAITFOR DELAY '00:01:00:000'
--wait for 1 millisecond
WAITFOR DELAY '00:00:00:001'
2. 定时闹钟功能: WAITFOR TIME
WAITFOR TIME '15:51:00.000'
RAISERROR('it is time 15:51:00.000', 0, 1) WITH NOWAIT