select distinct(datepart(month,convert(varchar(10),Consumetime,120))) as m ,sum(ConsumeTotal) as cout
from dbo.T_Consume
where datepart(year,convert(varchar(10),Consumetime,120))="2011" and Ph
转自http://www.cnblogs.com/oec2003/archive/2009/06/04/1496541.html
首先创建数据表
Create table Counter( CounterID int identity(1,1) not null, IP varchar(20), AccessDateTime