ISNULL(字段,0)用后无变化selectdistinctStudentName,StudentNumber,[NumberofCompletedExercise],[AverageTime],StudentIDfrom#PersonListleftjoin(selectPersonID,ISNULL(count(Completed),0)as[NumberofCompletedExercise]fromUserTransactio

Question

ISNULL(字段,0) 用后无变化
select distinct
StudentName,
StudentNumber,
[Number of Completed Exercise],
[Average Time],
StudentID
from #PersonList
left join (select PersonID,ISNULL(count(Completed),0) as [Number of Completed Exercise]
from UserTransaction.UserExercises
group by PersonID)M
on M.PersonID=#PersonList.StudentID
left join (select PersonID,UserExerciseID from UserTransaction.UserExercises) Q
on Q.PersonID=#PersonList.StudentID
left join (select UserExerciseID,ISNULL(avg(seconds),'') as [Average Time]
from UserTransaction.UserExerciseTime
group by UserExerciseID)N
on N.UserExerciseID=Q.UserExerciseID
order by StudentNumber
END
GO
运行后空值没有变为0,

Answer 1

看!你们没看见一条迷人的大腿在前进!
微酸,我感觉到
润的黎明,蓝黑水在进行蓝黑的溶化.
你有福了,无人.
死一样沉寂.我把蜘蛛网挂在灯罩上.
草原无边海洋无际哈哈