摘要:
直接上代码,按月实现数据分区,归档USE [db2]GO/****** Object: StoredProcedure [dbo].[partion_MoveScheme] Script Date: 04/20/2011 18:41:07 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROC [dbo].[partion_MoveScheme]AS BEGIN DECLARE @nextpartition DATETIME, @curdate DATETIME SET @curdate = '2011-7-1 阅读全文