Satyaprakash Samantaray
How to execute sql query after specific time given In SQL SERVER?
By Satyaprakash Samantaray in SQL Server on Feb 09 2017
  • Subhashkumar Yadav
    Feb, 2017 10

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

    • 7
  • sushil kumar
    Feb, 2017 23

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

    • 3
  • sushil kumar
    Feb, 2017 23

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

    • 2
  • sushil kumar
    Feb, 2017 23

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

    • 2
  • sushil kumar
    Feb, 2017 23

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

    • 2
  • sushil kumar
    Feb, 2017 23

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

    • 2
  • Lokesh Kumar
    Feb, 2017 20

    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

    • 2
  • Satyaprakash Samantaray
    Feb, 2017 10

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

    • 2
  • Satyaprakash Samantaray
    Feb, 2017 9

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

    • 2
  • Manav Pandya
    Mar, 2017 16

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

    • 1
  • Mukesh Kumar
    Sep, 2017 10

    Delay fn

    • 0
  • Mukesh Kumar
    Sep, 2017 10

    Delay fn

    • 0
  • Soniya Patel
    Sep, 2017 5

    using SET server output on

    • 0
  • Mukesh Kumar
    Aug, 2017 29

    Using delay function

    • 0
  • Mukesh Kumar
    Aug, 2017 28

    by using delay function

    • 0
  • Mukesh Kumar
    Aug, 2017 23

    by the use of delay fn delay(time)

    • 0