跨库备份指定日期前数据表,然后从原表删除

        public bool BackupAA()

        {

            int temp = 0;

            int tempdel = 0;

            string sql = "INSERT INTO  [WMSBAK].[dbo].[AACopy] SELECT * FROM  [TestDB].[dbo].[AA] WHERE AddDate <= DATEADD( d ,-45,GETDATE())";

            try

            {

                temp = dbhelper.ExcuteNonequery(sql);

            }

            catch (Exception)

            {

            }

            if (temp > 0)

            {

                string delsql = "DELETE [TestDB].[dbo].[AA] WHERE AddDate < DATEADD( d ,-45,GETDATE())";

                try

                {