A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Automated process to truncate a table
Joined: Aug 23, 2012
Aug 23, 2012 00:38:57
We have a table where we keep track of recent transactions.
Whenever the no.of records count reaches 10000 we truncate the table.
Till now we are doing this process manually.
Is there any automated process to write a procedure and schedule it to complete this activity.
Joined: Jul 20, 2005
Aug 23, 2012 01:35:39
Please do not create multiple topics for the same question. Please continue discussion in your other thread here
I agree. Here's the link:
subject: Automated process to truncate a table
deleting records in smaller chunks and issuing commit?
Problem in updating/deleting data from MS Access Database
Java DB - Delete all records in a table.
how to truncate table?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013