sqlÁ½Áкϲ¢ÏÔʾ£¿

²éѯ½á¹û¼¯£º
ps  online  totle
a    0      10
b    1      11
c    5        8
ÏëÏÔʾ³ÉÕâÑù
ps      exp
a    (0)|(10)
b    (1)|(11)
c    (5)|(8)

ÈçºÎдsql

---

SQL code:
select
ps,
'('ltrim(online)+')|('+ltrim(totle)+')' as exp
from
tb

---

SQL code:
select ps , exp = '(' + cast(online as varchar) + ')|(' + cast(total as varchar) + ')' from tb

---

SQL code:
select ps,exp='('+cast(online as varchar(10))+')|('+cast(totle as varchar(10))+')' from ±í

---

SQL code:

--> ²âÊÔÊý¾Ý£º@tb
declare @tb table([ps] varchar(1),[online] int,[totle] int)
insert @tb
select 'a',0,10 union all
select 'b',1,11 union all
select 'c',5,8




select ps,exp='('+ltrim(online)+')'+'('+ltrim([totle])+')' from @tb

/*
ps exp
---- ----------------------------
a (0)(10)
b (1)(1