Declare @tmp varchar(200) set @tmp=''
select top 10 @tmp=@tmp+','+ convert(varchar,feedbackid)
FROM data_table
where y=2011 and m=1 ORDER BY NEWID()
------------------
如何把这个语句改成存储过程来执行呀?谢谢
select top 10 @tmp=@tmp+','+ convert(varchar,feedbackid)
FROM data_table
where y=2011 and m=1 ORDER BY NEWID()
------------------
如何把这个语句改成存储过程来执行呀?谢谢
as
Declare @tmp varchar(200) set @tmp=''
select top 10 @tmp=@tmp+','+ convert(varchar,feedbackid)
FROM data_table
where y=2011 and m=1 ORDER BY NEWID()
go
exec p[/code]
如果我想执行后输出@tmp的值,应该怎么做啊?谢谢
@tmp varchar(200) output
as
--Declare @tmp varchar(200)
set @tmp=''
select top 10 @tmp=@tmp+','+ convert(varchar,feedbackid)
FROM data_table
where y=2011 and m=1 ORDER BY NEWID()
godeclare @str varchar(200)
exec p @str output
select @str