34,838
社区成员




declare @aa varchar(1000)
select @aa=isnull(@aa+'/','')+ cast(ID as varchar) from table where ID> 0
select @aa
declare @t table (ID int)
insert into @t select 1
insert into @t select 2
insert into @t select 3
insert into @t select 4
insert into @t select 5
declare @sql nvarchar(1000)
select @sql=isnull(@sql,' ')+'/'+cast(ID as nchar(3)) from @t
print @sql
-- /1 /2 /3 /4 /5