16
Reply

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

    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

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

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

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

    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

    Delay fn

    using SET server output on

    Using delay function

    by using delay function

    by the use of delay fn delay(time)