oracle查询结果拼接字符串,sqlserver拼接字符串

select faulttype ||'(1111 ) '|| nodetype|||||||||||||||||||||| ' ) as title from t _ KPI _ fau fau fau u