declare @a table(id int)
insert @a(id)
values(1)
insert @a(id)
values(2)
insert @a(id)
values(3)select * from @a
declare @num int
set @num=(select count(id) from @a)
DECLARE @counter smallint
SET @counter = 1
declare @id varchar(10)
declare @Str varchar(100)
set @Str=''
WHILE @counter < @num+1
BEGIN set @id=(select id from @a where id=@counter)
--select @id
set @Str=@Str+@id+'~' SET NOCOUNT ON
SET @counter = @counter + 1
SET NOCOUNT OFF
END
select @Str
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货