use food
go
create partition function pf_eva_date(datetime)
as range left
for values(2012)
--创建分区方案
create partition scheme ps_eva_date
as partition pf_eva_date to(datagroup1,datagroup2)
--创建分区表
CREATE TABLE evaluate1_table NULL,
[eva_grade] [int] NOT NULL,
[vip_id] [int] NOT NULL
) ON pf_eva_date(eva_date )