摘要：
CREATE TABLE SolarData ( yearId int not null primary key, data char(7) not null, dataInt int not null ) go--插入数据 INSERT INTO SolarData SELECT 1900,'0x04bd8',19416 UNION ALL SELECT 1901,'0x04ae0',19... 阅读全文
摘要：
2、语法select year,jan,feb,mar,apr,may,jun,jul,aug,sep,oct,nov,decfrom salesbymonthpivot ( sum(amount) for month in (jan,feb,mar,apr,may,jun,jul,aug,sep,oct,nov,dec)) as ourpivot 阅读全文