SQL SERVER – Delay Command in SQL Server – SQL in Sixty Seconds #055
Posted
by Pinal Dave
on SQL Authority
See other posts from SQL Authority
or by Pinal Dave
Published on Wed, 17 Jul 2013 01:30:09 +0000
Indexed on
2013/08/02
15:48 UTC
Read the original article
Hit count: 1029
database
|Pinal Dave
|PostADay
|sql
|SQL Authority
|SQL in Sixty Seconds
|SQL Interview Questions a
|SQL Query
|SQL Scripts
|SQL Server
|SQL Tips and Tricks
|T SQL
|Technology
|video
|Identity
Have you ever needed WAIT or DELAY function in SQL Server? Well, I personally have never needed it but I see lots of people asking for the same. It seems the need of the function is when developers are working with asynchronous applications or programs. When they are working with an application where user have to wait for a while for another application to complete the processing.
If you are programming language developer, it is very easy for you to make the application wait for command however, in SQL I personally have rarely used this feature. However, I have seen lots of developers asking for this feature in SQL Server, hence I have decided to build this quick video on the same subject.
We can use WAITFOR DELAY ‘timepart‘ to create a SQL Statement to wait.
Let us see the same concept in following SQL in Sixty Seconds Video:
Related Tips in SQL in Sixty Seconds:
What would you like to see in the next SQL in Sixty Seconds video?
Reference: Pinal Dave (http://blog.sqlauthority.com)
Filed under: Database, Pinal Dave, PostADay, SQL, SQL Authority, SQL in Sixty Seconds, SQL Interview Questions and Answers, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, Video Tagged: Identity
© SQL Authority or respective owner
