--创建基础数据表
if object_id('SolarData') is not null
    drop table SolarData
go
create table SolarData  
(  
  yearid int not null,  
  data char(7) not null,  
  dataint int not null  
)   
--插入数据  
insert into   
SolarData select 1900,'0x04bd8',19416 union all select 1901,'0x04ae0',19168  
union all select 1902,'0x0a570',42352 union all select 1903,'0x054d5',21717  
union all select 1904,'0x0d260',53856 union all select 1905,'0x0d950',55632  
union all select 1906,'0x16554',91476 union all select 1907,'0x056a0',22176  
union all select 1908,'0x09ad0',39632 union all select 1909,'0x055d2',21970  
union all select 1910,'0x04ae0',19168 union all select 1911,'0x0a5b6',42422  
union all select 1912,'0x0a4d0',42192 union all select 1913,'0x0d250',53840  
--后面省略。。。