如何在SQL中解决isnull（）

问题描述

Hello Team，

Hello Team,

-----------------heere we want Updated By Name

select  c.ID as CUSTOMERLOANDATAID,c.FIRSTNAME,c.LASTNAME,
 isnull(UU.FIRSTNAME + ' '+ UU.LASTNAME,'') as  UpdatedByName
 from CUSTOMERLOANDATA c with(nolock)
Left Outer join USERMASTER UU (nolock) on UU.ID = C.UpdatedBy
where FILELOGID=(select top(1) filelogid  from CUSTOMERLOANDATA with(nolock) where
 QCUSERID = 13
ORDER BY FILELOGID)
and
 QCUSERID = 13
 ORDER BY FILELOGID, RECORDNO

isnull是什么（UU.FIRSTNAME +''+ UU.LASTNAME，''）意思是???



请告诉我..



谢谢

Harshal

what does isnull(UU.FIRSTNAME + ' '+ UU.LASTNAME,'') it mean ???

please let me know ..

Thanks
Harshal

推荐答案

select (columname,0)Amount from table

然后结果是

then the result is

Amount
null

但是如果你使用isnull函数

but if you using isnull function

select isnull(columname,0)Amount from table

Amount
0

这篇关于如何在SQL中解决isnull（）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！