What is WaitFor Delay in Sql Server?

 Posted by Vishalneeraj-24503 on 3/1/2015 | Category: Sql Server Interview questions | Views: 319 | Points: 40
Answer:

WaitFor Delay is used to wait a specified Period of a Time. When Sql Server encounters WaitFor Delay,then it immediately pauses operation of a Sql statement.It does not move to the next command or statement until the specified period of time has elapsed.Once the specified Interval has elapsed,Sql Server resumes the execution of Sql Statement,starting with the command immediately after the Waitfor Delay Command.
Syntax:-
WaitFor Delay period_of_Time


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response