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