34,590
社区成员
发帖
与我相关
我的任务
分享
if object_id(N'tempdb..#T') is not null
drop table #T
go
create table #T
(
sql1 varchar(128),
sql2 varchar(128)
)
go
insert into #T
select '11111','22222' union all
select '33333','44444'
go
select
isnull(sql1,'')+'/'+isnull(sql2,'') as [拼接]
from #T
drop table #T
select isnull(sql1,'null')+'/'+isnull(sql2,'null') from Tablename
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([sql1] int,[sql2] int)
Insert #T
select 11111,22222
Go
--测试数据结束
SELECT RTRIM(sql1)+'/'+RTRIM(sql2) from #T