How to execute sql query after specific time given In SQL SERVER?
Satyaprakash Samantaray
Give the Delay time e.g waitfor delay '00:00:01'
write WAITFOR DELAY '00:00:02' before SQL QUERY Example:-WAITFOR DELAY '00:00:02' Select * from tableNamethis will delay query execution for seconds
You can use the following :- WAITFOR DELAY '00:00:20'; select * from tablename For delaying the execution of 20 secand WAITFOR Time '00:04:20'; select * from tablename For delaying the execution particular time
Yes Mr. Subash You can , WAITFOR DELAY '00:00:01'; SELECT * FROM table_nameAfter 1 seconds time the sql query will be executed.
WAITFOR DELAY '00:00:04'; SELECT * FROM table_name After 4 seconds time the sql query will be executed.
you can use "check Occur once" or delay also as per your requirements
Delay fn
using SET server output on
Using delay function
by using delay function
by the use of delay fn delay(time)