将记录从一个表移动到存档表 [英] Move Records from one table to an Archive table

问题描述

我有几张桌子越来越大，因此越来越慢。  我希望当患者已停用365天或更长时间时，将旧的非活动患者记录从一个表移动到存档表（完全重复）。  我知道我可以
创建合格记录的记录集并执行INSERT INTO然后执行DELETE。 

I have several tables that are getting large, therefore, getting slower.  I want to move old inactive patient records from one table to an Archive table (exact duplicate) when the patient have been off service for 365 days or more.  I know I can create a recordset of qualifying records and perform an INSERT INTO and then a DELETE. 

是否有一个简单的单步方法来完成此任务？

Is there a simple single step way to accomplish this task?

感谢任何反馈或帮助。

提前谢谢

BrianS

推荐答案

嗨Brian。只是好奇，你的桌子有多少条记录？我认为将数据从一个表移动到另一个表只有一个步骤，但您始终可以使用单个调用自动执行多个步骤。只是我的2美分......

Hi Brian. Just curious, how many records does your table have? I don't think there is a single step to move the data from one table to another but you can always automate multiple steps using a single call. Just my 2 cents...

这篇关于将记录从一个表移动到存档表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！