:::: MENU ::::

Interupting WAIT FOR in T-SQL

  • Jan 07 / 2010
  • 1
dbDigger, T-SQL Interview Questions, T-SQL Tips and Tricks

Interupting WAIT FOR in T-SQL

Question:

Which of the following items can be used to end a WAITFOR statement in SQL Server 2005?

Answer:

  • specific time
  • An elapsed period of time
  • A message in a Service Broker queue
  • A timeout

Explanation: All of these can actually end a WAITFOR statement. You can pick a particular time or an amount of time that elapses in the statement. You can also specify that the WAITFOR ends when a message is received in a Service Broker queue, or a timeout passes in waiting for that message.

Note: The question of day is taken from SqlServerCentral.com. I want to compile selected QOD to share.

  • Anonymous

    Please clarify that from which version of SQL Server "WAIT FOR" is included onwards?

Consult us to explore the Databases. Contact us