COALESCE
COALESCE ( expression,value1,value2……,valuen)
如果expression为空则返回value1,不空则返回expression
若value1仍为空则返回value2....以此类推
常用e.g
coalesce(@d,0)
COALESCE
COALESCE ( expression,value1,value2……,valuen)
如果expression为空则返回value1,不空则返回expression
若value1仍为空则返回value2....以此类推
常用e.g
coalesce(@d,0)