SQL归档

最新推荐文章于 2022-03-18 19:24:02 发布

weixin_30294021

最新推荐文章于 2022-03-18 19:24:02 发布

阅读量131

点赞数

原文链接：http://www.cnblogs.com/callbin/p/4459182.html

版权

/*
作用：归档3个月前的短信发送记录
创建人：zhuxiang
日期：2012-10-30
*/
ALTER Proc [dbo].[Sms_Job_History_Send]
As
Begin
	Declare @Temp table (MsgID varchar(20))
	Declare @Time datetime Set @Time = DateAdd(mm,-3,getdate())
	
	--检索出需要归档的记录
	Insert Into @Temp(MsgID)
	Select top 5000 MsgID From IB_Sms_Send_Bill(nolock) Where SubmitTime < @Time and State = 9
	
	--删除主表
	Delete a
	Output deleted.*
	Into ytFax_DB_History..IB_Sms_Send_Bill
	From IB_Sms_Send_Bill a,@Temp b
	Where a.MsgID = b.MsgID
	
	--删除明细表
	Delete a
	Output deleted.*
	Into ytFax_DB_History..IB_Sms_Send_Detail_Bill
	From IB_Sms_Send_Detail_Bill a,@Temp b
	Where a.MsgID = b.MsgID
End

转载于:https://www.cnblogs.com/callbin/p/4459182.html