一个简单的存储过程

create procedure proc_pay
(@maxmoney int,
@minmoney int,
@paymonth nvarchar(20))
as 
begin
	select 储值方式,sum(台币) from 储值分析 where uid in
 (select uid from 储值分析 where Paymonth=@paymonth group by uid having sum(台币) between @minmoney and @maxmoney) group by 储值方式 
 
end

 就是C#的方法嘛

posted @ 2014-08-13 12:55  南瓜asp  阅读(166)  评论(0编辑  收藏  举报