Give any example of WaitFor Delay Command?

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

SELECT GETDATE() CurrentTime;

WAITFOR DELAY '00:00:10' 10 Second Delay
SELECT GETDATE() CurrentTime;


WAITFOR DELAY '10:30';
--10 Hours and 30 Minutes


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response