请教一条SQL语句 - MS-SQL Server / 基础类

字段 A B
  100 ff
  101 dd
  102 gg

我想把两列合并 变成
  100:ff
  101:ff
  102:gg

---

SQL code:
--> 测试数据: #tb
if object_id('tempdb.dbo.#tb') is not null drop table #tb
go
create table #tb (A int,B varchar(2))
insert into #tb
select 100,'ff' union all
select 101,'dd' union all
select 102,'gg'

select cast(A as varchar(10))+':'+B from #tb

-------------
100:ff
101:dd
102:gg

(3 行受影响)

---

引用

字段 A B
100 ff
101 dd
102 gg

我想把两列合并 变成
100:ff
101:ff
102:gg

select ltrim(a) + ':' + b from tb

select cast(a as varchar) + ':' + b from tb

---

SQL code:

select rtrim(ltrim(A))+':'+rtrim(ltrim(B)) from tt

---

SQL code:
select ltrim(A)+':'+B from tb

---

原来是个函数就可以了。谢谢了。。。