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