34,838
社区成员




select isnull(A,'')+isnull(b,'')+isnull(c,'')+isnull(d,'')+isnull(e,'')+isnull(f,'')+isnull(g,'') as name from [table]
selst col=isnull(A,'')+isnull(b,'')+isnull(c,'')+isnull(d,'')+isnull(e,'')+isnull(f,'')+isnull(g,'') form tb
selst isnull(A,'')+isnull(b,'')+isnull(c,'')+isnull(d,'')+isnull(e,'')+isnull(f,'')+isnull(g,'') as name form [table]
selst
isnull(A,'')+
isnull(B,'')+
isnull(C,'')+
isnull(D,'')+
isnull(E,'')+
isnull(F,'')+
isnull(G,'') as name
form table
selst isnull(A,'')+isnull(b,'')+isnull(c,'')+isnull(d,'')+isnull(e,'')+isnull(f,'')+isnull(g,'') as name form [table]
ISNULL(a,'')+ISNULL(b,'')+ISNULL(c,'')