在Sql Server中根据月份建立表，实现分区视图

 1.首先建立一张月份对应英文缩写的字典表如下:

Order_Month_Number     Order_Month_English
1                                                      Jan
2                                                      Feb
3                                                      Mar
..                                                      ..

分别建立相应的月表:
对于插入操作:

 DECLARE @InsertString NVARCHAR(2000) --插入Sql
 Declare @CardNo varchar(10),
         @DeptNo varchar(5),@DeptName varchar(10) 
Select @InsertString = 'INSERT INTO TB_' +
         ltrim(rtrim(dbo.GetOrderMonthEnglish (DATENAME(mm, '2005-01-01'))))+
         '_Regist(Card_No,Dept_No,Dept_Name) '+
         'values(@InsCardNo,@InsDeptNo,@InsDeptName)'

  EXEC sp_executesql @InsertString,
     N'@InsCardNo varchar(10),
         @InsDeptNo varchar(5),@InsDeptName varchar(10)', 
       @CardNo,@DeptNo,@DeptName