T-SQL筆記35_類似Thread Sleep的語法_WAITFOR DELAY

 

延遲一秒再往下執行

1 2	-- wait for 1 second WAITFOR DELAY '00:00:01'

延遲一分鐘再往下執行

1 2	-- wait for 1 minute WAITFOR DELAY '00:01'

Ref:

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/waitfor-transact-sql?redirectedfrom=MSDN&view=sql-server-ver16

https://stackoverflow.com/questions/664902/sleep-command-in-t-sql