The documentation for WAITFOR()
doesn’t explicitly lay out the required string format.
This will wait for 2 seconds:
WAITFOR DELAY '00:00:02';
The format is hh:mi:ss.mmm
.
More Related Contents:
- Comma separated results in SQL
- How to check if a column exists in a SQL Server table
- Understanding PIVOT function in T-SQL
- Using T-SQL, return nth delimited element from a string
- Get first day of week in SQL Server
- Using RegEx in SQL Server
- How do you view ALL text from an ntext or nvarchar(max) in SSMS?
- Confused about UPDLOCK, HOLDLOCK
- INSERT INTO vs SELECT INTO
- SQL Server 2008 Empty String vs. Space
- How do I use the CONCAT function in SQL Server 2008 R2?
- How to set a default value for an existing column
- Select / Insert version of an Upsert: is there a design pattern for high concurrency?
- TSQL: How to convert local time to UTC? (SQL Server 2008)
- SQL Server: combining multiple rows into one row
- How do I find a stored procedure containing ?
- SQL Recursive CTE: Finding objects linked by property
- How to convert number of minutes to hh:mm format in TSQL?
- Convert decimal time to hours and minutes
- SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
- How do I move a table into a schema in T-SQL
- Instead of trigger in SQL Server loses SCOPE_IDENTITY?
- How Can I Detect and Bound Changes Between Row Values in a SQL Table?
- What are row, page and table locks? And when they are acquired?
- Generate MD5 hash string with T-SQL
- How do I escape a percentage sign in T-SQL?
- SqlServer: Login failed for user
- SQL Server error on update command – “A severe error occurred on the current command”
- SQL server schema and default schema
- SQL to find first non-numeric character in a string