SQL Server 连接字符串
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