SQLSERVER迁移数据并删除历史记录

SQL SERVER迁移数据并删除历史记录 ?12345678910111213141516171819202122232425262728293031323334353637383940414243

SQL SERVER迁移数据并删除历史记录 ? 1 01 2 USE [bak] 3 02 4 GO 5 03 6 /****** Object: StoredProcedure [dbo].[pro_pay591_J_orderlog_clear] Script Date: 08/07/2013 13:53:49 ******/ 7 04 8 SET ANSI_NULLS ON 9 05 10 GO 11 06 12 SET QUOTED_IDENTIFIER ON 13 07 14 GO 15 08 16 -- ============================================= 17 09 18 -- Author: <myun> 19 10 20 -- Create date: <2013-08-07> 21 11 22 -- Description: <清理主数据库订单日志> 23 12 24 -- ============================================= 25 13 26 ALTER PROCEDURE [dbo].[pro_pay_orderlog_clear] 27 14 28 @dt_end datetime --清理此日期之前的数据 29 15 30 AS 31 16 32 BEGIN 33 17 34 -- SET NOCOUNT ON added to prevent extra result sets from 35 18 36 -- interfering with SELECT statements. 37 19 38 SET NOCOUNT ON; 39 20 40