table:
Column1 | Column2 | Column3 |
Value1 | Null |
SELECT Column1+Column2+Column3 will return Null
SELECT Column1+Column2+IsNull(Column3,'') return Value1
table:
Column1 | Column2 | Column3 |
Value1 | Null |
SELECT Column1+Column2+Column3 will return Null
SELECT Column1+Column2+IsNull(Column3,'') return Value1
转载于:https://www.cnblogs.com/slow3/p/5093033.html