select case then t1.cnt = t2.cnt then '所有姓张的学生是否都及格了' else '有张姓学生不及格' end from
(select cnt = count(*) from tb where name like '张%') t1,
(select cnt = count(*) from tb where name like '张%' and fs >= 60) t2
(select cnt = count(*) from tb where name like '张%') t1,
(select cnt = count(*) from tb where name like '张%' and fs >= 60) t2
where nanme like '%'+@name+'%'---或者
select * from studentTasble
where nanme like '%'+@name+'%'
and fenshu>60
print '所有姓张的学生是否都及格了'
else
print '有张姓学生不及格'