create proc p_qry
@s varchar(8000) output,
@id int=4
as
set @s=''
select @s=@s+','+msg from userreq where id=@id
set @s=stuff(@s,1,1,'')
@s varchar(8000) output,
@id int=4
as
set @s=''
select @s=@s+','+msg from userreq where id=@id
set @s=stuff(@s,1,1,'')
declare @s varchar(8000)
exec p_qry @s out
select 结果=@s