create procedure prof
@a char(8),@d char(8)
as
select count(*)
declare @b int,@c int, @e int
select @b=avg(age) ,@c =avg(comm) ,@e = max(comm)
from teacher
where @a = teacher.dept and @d = teacher.prof
print @b print @c print @e
为什么没有用?
不能输出 @b @c @e
希望改一下可以输出