IF-ELSE语句
ELSE是可选部分,如果有多条语句,才需要BEGIN-NED语句块。
use StuManageDB
go
declare @cAvg int
Select @cAvg=avg(CSharp)from ScoreList
inner join Students on ScoreList.StudentId=Students.StudentId where ClassId=1
Print 'C#平均成绩: ' + Convert(varchar(20),@cAvg)
--判断成绩
if(@cAvg>