16
Reply

How to execute sql query after specific time given In SQL SERVER?

Satyaprakash Samantaray

Satyaprakash Samantaray

Feb 09, 2017
2.9k
4

    Give the Delay time e.g waitfor delay '00:00:01'

    Subhashkumar Yadav
    February 10, 2017
    7

    write WAITFOR DELAY '00:00:02' before SQL QUERY Example:-WAITFOR DELAY '00:00:02' Select * from tableNamethis will delay query execution for seconds

    sushil kumar
    February 23, 2017
    3

    write WAITFOR DELAY '00:00:02' before SQL QUERY Example:-WAITFOR DELAY '00:00:02' Select * from tableNamethis will delay query execution for seconds

    sushil kumar
    February 23, 2017
    2

    write WAITFOR DELAY '00:00:02' before SQL QUERY Example:-WAITFOR DELAY '00:00:02' Select * from tableNamethis will delay query execution for seconds

    sushil kumar
    February 23, 2017
    2

    write WAITFOR DELAY '00:00:02' before SQL QUERY Example:-WAITFOR DELAY '00:00:02' Select * from tableNamethis will delay query execution for seconds

    sushil kumar
    February 23, 2017
    2

    write WAITFOR DELAY '00:00:02' before SQL QUERY Example:-WAITFOR DELAY '00:00:02' Select * from tableNamethis will delay query execution for seconds

    sushil kumar
    February 23, 2017
    2

    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

    Lokesh Kumar
    February 20, 2017
    2

    Yes Mr. Subash You can , WAITFOR DELAY '00:00:01'; SELECT * FROM table_nameAfter 1 seconds time the sql query will be executed.

    Satyaprakash Samantaray
    February 10, 2017
    2

    WAITFOR DELAY '00:00:04'; SELECT * FROM table_name After 4 seconds time the sql query will be executed.

    Satyaprakash Samantaray
    February 09, 2017
    2

    you can use "check Occur once" or delay also as per your requirements

    Manav Pandya
    March 16, 2017
    1

    Delay fn

    Mukesh Kumar
    September 10, 2017
    0

    Delay fn

    Mukesh Kumar
    September 10, 2017
    0

    using SET server output on

    Soniya Patel
    September 05, 2017
    0

    Using delay function

    Mukesh Kumar
    August 29, 2017
    0

    by using delay function

    Mukesh Kumar
    August 28, 2017
    0

    by the use of delay fn delay(time)

    Mukesh Kumar
    August 23, 2017
    0