Microsoft KB Archive/50209

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

PRB: Using Datetime Variable w/ WAITFOR TIME or WAITFOR DELAY ID Number: Q50209

1.10 1.11 4.20 OS/2

Summary:

SYMPTOMS Neither WAITFOR TIME nor WAITFOR DELAY will accept a variable for the “time” parameter.

CAUSE This is a limitation of SQL, and currently there are no plans to modify this behavior.

RESOLUTION If you try to use a datetime variable with WAITFOR TIME or WAITFOR DELAY, as the following sequence of ISQL statements attempt, you receive a syntax error on line 3, referring to the variable “@i”. There is no way to work around this limitation. You must use a constant value, as demonstrated in the second example listed below.

The following sequence of statements generates a syntax error on line 3:

  1>DECLARE @i datetime
  2>SELECT @i="02:25"
  3>WAITFOR TIME @i
  4>GO

The following sequence of statements works correctly:

  1>WAITFOR TIME "02:25"
  2>GO

Additional reference words: Transact-SQL