27,579
社区成员
发帖
与我相关
我的任务
分享
--任何值与NULL结合,结果为NULL
select A,B,A+isnull(B,'') FROM TEST
select A,B,A+isnull(B,'') from test
select A,B,A+isnull(B,'') from test
select A,B,isnull(A,0)+isnull(B,0) FROM TEST
select A,B,A+isnull(B,'') FROM TEST
select A,B,A+isnull(B,'') from test
select A,B,A+isnull(B,'') FROM TEST