ISNULL(expression,value) :
如果expression不为空则返回expression,否则返回value
SELECT ISNULL(FName,'佚名') as 姓名 FROM
T_Employee
ISNULL(expression,value) :
如果expression不为空则返回expression,否则返回value
SELECT ISNULL(FName,'佚名') as 姓名 FROM
T_Employee
转载于:https://www.cnblogs.com/DaiMaDi/archive/2013/02/28/2937040.html