Java – how do I limit the size of a table?

• Java

I have a SQL Server 2005 database I'm recording the data in the table I want to prevent the table data from getting too large

How to limit the size of a table to x rows and keep logging? I hope the oldest line can fall

Solution

You have to build the process yourself You may want to create a SQL Server job that runs an SQL delete statement based on the conditions you define

The content of this article comes from the network collection of netizens. It is used as a learning reference. The copyright belongs to the original author.
THE END
分享
二维码
< <上一篇
下一篇>>