你是说写一个查询这个结果的存储过程吗?试试这个!CREATE PROCEDURE [存储过程名称]( ) AS select [B] + '---' + [C] as [BC] from [A]GO
oracel 中 select B||'---'||C BC from tableAsybase/sqlserver select B+'---'+C BC from tableA
select B+'---'+C as BC from A