摘要：
/*第一步在数据库存储目录下新建一个分区方案*/USE [MultiCompany]GOCREATE PARTITION SCHEME [SCH_MC] AS PARTITION [FN_MC] TO ([SN2013], [PRIMARY])GO/*第二步在数据库存储目录下新建一个分区函数*/USE [MultiCompany]GOCREATE PARTITION FUNCTION [FN_MC](SMALLINT) AS RANGE RIGHT FOR VALUES (2014)GO/*第三步在需要转储的表里添加一个标签字段(本处是以年份作为标签的)*/ALTER TABLE Financ 阅读全文