PROCEDURE MULTIPLICATION OF THREE VARIABLE

create procedure avg_scoress @score1 smallint, @score2 smallint, @score3 smallint, @myavg smallint output as select @myavg=(@score1+@score2+@score3)/3 --Execute Procedure declare @avgscore smallint Exec avg_scoress 20,30,30,@avgscore output select'  The average score is :' as 'Result',@avgscore as 'Operation'

Output