ISNULL ( check_expression , replacement_value )
简单点的说就是如果check_expression为空的话,就用replacement_value来代替,否则就直接用check_expression
举个例子:SELECTISNULL ( check_expression , replacement_value ) AS '显示的值'
FROM ......
ISNULL ( check_expression , replacement_value )
简单点的说就是如果check_expression为空的话,就用replacement_value来代替,否则就直接用check_expression
举个例子:SELECTISNULL ( check_expression , replacement_value ) AS '显示的值'
FROM ......