xx表里有一datetime字段 现在要写一存储过程: create PROCEDURE [dbo].[test] @year int AS BEGIN //传入一个“年的参数”,目的想把这一年的所有记录按月份显出出来 请问这个sql END 结果: score 为同月的总结 month score 1 xx 2 xx 。。 ..
create PROCEDURE [dbo].[test]
@year varchar(4)
AS
BEGIN
select [month] = month(date),score = sum(score) from table1
where year(date) = @year
group by month(date) datepart(datefield,yy) = @year
END
create PROCEDURE [dbo].[test]
@year varchar(4)
AS
BEGIN
select month = datepart(datefield,mm),score = sum(score) from table1 group by datepart(datefield,yy),datepart(datefield,mm) having datepart(datefield,yy) = @year
END