The actual scene:
Database has a data table, there are a large amount of data generated every day, every day query data from the day's
Best can cycle through set the starting time to the current query time data are output

At the same time there are a few other table query whether (executing scripts) can also according to the cycles of time automatically output

CodePudding user response:

Write a statement, to create a schedule,

CodePudding user response:

Use the Sql Agent (Agent) can do homework time task:

CodePudding user response:

Do a view table, or written in proc,
On the proxy plan execution,

You can query anytime and anywhere, not very hard

CodePudding user response:

Use plan, task execution statement set a variable assignment using date function, so that you can query a day

CodePudding user response:

reference half a bottle of water, 4/f, also want to full reply:

task using plan, execute statement set a variable assignment using date function, so that you can query a day of the

My question is this, how to automatically, time,
Select * from table name
Where time> 'time and the time & lt; 'time'

Where is that this result is the output again?

CodePudding user response:

reference 5 floor qqluciferzy reply:

Quote: refer to 4th floor half a bottle of water would fill response:

Use plan, task execution statement set a variable assignment using date function, so that you can query a day of the

My question is this, how to automatically, time,
Select * from table name
Where time> 'time and the time & lt; 'time'

Where is that this result is the output again?

You are creating a result table, put the output result table