What is WaitFor Time in Sql Server?

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

WaitFor Time is used to wait untill a specified Time of a Day.When Sql Server encounters WaitFor Time,then it pauses operation of a Sql statement until the next occurance of a specified time within a 24-hour interval.Once the particular time reaches,then it starts execution.
Syntax:-
WaitFor Time Time


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response