SQL Server 连接字符串

table:

Table
Column1 Column2 Column3
Value1   Null

SELECT Column1+Column2+Column3 will              return Null

SELECT Column1+Column2+IsNull(Column3,'')     return Value1

 

posted @ 2016-01-01 10:01  Slow^3  阅读(144)  评论(0编辑  收藏  举报