ISNULL(expression,value) :
如果expression不为空则返回expression,否则返回value
SELECT ISNULL(FName,'佚名') as 姓名 FROM
T_Employee