自动查询执行 [英] Automatic Query execution

问题描述

我想在几个时间间隔内实现自动查询执行.根据用户给出的时间限制，我需要自动执行查询... plz帮助我做到这一点.

I want to implement automatic query execution in several intervals.According to the time limit given by the user i need to execute the query automatically...plz help me to do it.

推荐答案

您可以将查询配置到数据库本身.您将查询配置为数据库中的作业，该作业将根据用户要求在特定的时间间隔内运行.
作业在oracle数据库和MSSQL服务器数据库中都是可用的.

You can configure your query into the database itself. You configure your query as the job in database which will run in particular time interval as per the user requirement.
The jobs are available in both oracle and MSSQL server database

使用Timer Control在几个时间间隔内执行查询.
将计时器的间隔设置为用户的标准要求.
将代码插入计时器的滴答事件"中.

Use Timer Control to execute query in several intervals.
Set interval of Timer as par requirement of users.
Insert your code into Tick Event of Timer.

这篇关于自动查询执行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！