当你是MSSQL1、create function fn_avgincome(@bdate datetime,@edate datetime) returns Moneybeginreturn(select avg(AMonthIncome) from AdopterInfo a,AdoptRecord b where a.AID=b.AID and b.Time between @bdate and @edate)end2、普通语句create proc sp_test asbeginupdatea set ATime=ATime+1 from AdoptRecord awhere exists