sql 把两条数据拼接为一条数据
select stuff((select '、'+c_nmefrom alislb for xml path('')),1,1,'') as UserName,stuff((select '、'+c_pssfrom alislb for xml path('')),1,1,'') as Num,stuff((select '、' + RTRIM(c_regstt) from alislb for
·
select stuff((
select '、'+c_nme
from alislb for xml path('')),1,1,'') as UserName,stuff((
select '、'+c_pss
from alislb for xml path('')),1,1,'') as Num,
stuff((select '、' + RTRIM(c_regstt) from alislb for xml path ('')),1,1,'') as Num
更多推荐
已为社区贡献1条内容
所有评论(0)