【答案解析】Create function fun
(@class varchar(20),@orderyearChar(4)
Return int
As
Begin
Declare @tem smalldatatime
Declare @cnt int
set@tem=convert(smallaatetime,@orderyear)
select @cnt=sum(印刷数目)from 图书表 join 图书印刷表 on图书表.书号=图书印刷表.书号 where 类别=@class and 日期＞@tem
return @cnt
end