WAITFOR DELAY '00:00:01' : WAITFOR « Transact SQL « SQL Server / T-SQL Tutorial






2> CREATE TABLE T (
3>     int1 int,
4>     bit1 bit NOT NULL DEFAULT 0,
5>     rvr1 timestamp,
6>     usr1 nvarchar(128) DEFAULT USER,
7>     createtime datetime DEFAULT CURRENT_TIMESTAMP
8> )
9> GO
1>
2> INSERT T (int1, bit1) VALUES (2, 0)
3> WAITFOR DELAY '00:00:01'
4> GO
1>
2> drop table t;
3> GO








20.24.WAITFOR
20.24.1.Using WAITFOR
20.24.2.The WAITFOR Statement
20.24.3.The TIME Parameter
20.24.4.WAITFOR DELAY '00:00:01'