摘要: --**************** 存储过程 sql *******************Create procedure Proc_MoveSms_ToHistory as begin SET XACT_ABORT on BEGIN TRAN --批量插入到历史表 INSERT INTO dbo.SMS_T_SendLog SELECT a.ID, b.Host,b.Guest,a.SendedTime,b.State,GETDATE() AS AddTime, a.AgentID,a.Title,a.MsgC... 阅读全文
posted @ 2011-12-13 14:13 心_远 阅读(328) 评论(0) 推荐(0) 编辑