资源描述：
《数据库快照和分区表》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、------------------------------------------创建分区表begin----------------------------------------------------创建分区函数createpartitionfunctionPF_FQBTest_CreateDateRange(datetime)asrangerightforvalues('2010-1-1','2010-1-2','2010-1-3','2010-1-4','2010-1-5','2010-1-6','2010-1-7','2010-1-8','2010-1-9','2010-1-1
2、0','2010-1-11','2010-1-12','2010-1-13','2010-1-14','2010-1-15','2010-1-16','2010-1-17','2010-1-18','2010-1-19','2010-1-20','2010-1-21','2010-1-22','2010-1-23','2010-1-24','2010-1-25','2010-1-26','2010-1-27','2010-1-28','2010-1-29','2010-1-30','2010-1-31','2010-2-1','2010-2-2','2010-2-3','2010-2-4',
3、'2010-2-5','2010-2-6','2010-2-7','2010-2-8','2010-2-9','2010-2-10','2010-2-11','2010-2-12','2010-2-13','2010-2-14','2010-2-15','2010-2-16','2010-2-17','2010-2-18','2010-2-19','2010-2-20','2010-2-21','2010-2-22','2010-2-23','2010-2-24','2010-2-25','2010-2-26','2010-2-27','2010-2-28','2010-3-1','2010
4、-3-2','2010-3-3','2010-3-4','2010-3-5','2010-3-6','2010-3-7','2010-3-8','2010-3-9','2010-3-10','2010-3-11','2010-3-12','2010-3-13','2010-3-14','2010-3-15','2010-3-16','2010-3-17','2010-3-18','2010-3-19','2010-3-20','2010-3-21','2010-3-22','2010-3-23','2010-3-24','2010-3-25','2010-3-26','2010-3-27',
5、'2010-3-28','2010-3-29','2010-3-30','2010-3-31','2010-4-1','2010-4-2','2010-4-3','2010-4-4','2010-4-5','2010-4-6','2010-4-7','2010-4-8','2010-4-9','2010-4-10','2010-4-11','2010-4-12','2010-4-13','2010-4-14','2010-4-15','2010-4-16','2010-4-17','2010-4-18','2010-4-19','2010-4-20','2010-4-21','2010-4-
6、22','2010-4-23','2010-4-24','2010-4-25','2010-4-26','2010-4-27','2010-4-28','2010-4-29','2010-4-30','2010-5-1','2010-5-2','2010-5-3','2010-5-4','2010-5-5','2010-5-6','2010-5-7','2010-5-8','2010-5-9','2010-5-10','2010-5-11','2010-5-12','2010-5-13','2010-5-14','2010-5-15','2010-5-16','2010-5-17','201
7、0-5-18','2010-5-19','2010-5-20','2010-5-21','2010-5-22','2010-5-23','2010-5-24','2010-5-25','2010-5-26','2010-5-27','2010-5-28','2010-5-29','2010-5-30','2010-5-31','2010-6-1','2010-6-2','2010-6-3','2010-6-4
