xml path

 

create table myT

(
 
id int identity(1,1) primary key
 
,name varchar(20)

)
insert into myT values('lee1')

insert into myT values('lee2')

insert into myT values('lee3')

insert into myT values('lee4')
insert into myT values('lee5')

insert into myT values('lee6')

 

select (select convert(varchar(5),id) + ','   from myT for xml path('') ) as ids