怎样把Sql语句转化成存储过程语句,急

[jeall]

Sql = "Select A,B From Table1"
Set Rs = Conn.ExeCute(Sql)
If not Rs.Eof Then
s = ""
Do While Not Rs.Eof
s = s & Rs(0) &"+"& Rs(1)
Rs.MoveNext
Loop
End If

[arthur0729]

？游标

[jeall]

我不会存储过程，游标也没有用过，能具体说说么？

[子陌红尘]

create procedure sp_test(@str varchar(8000) output)
as
begin
set @str=''
Select @str=@str+' '+isnull(A,'')+'+'+isnull(B,'') From Table1
return
end
go

declare @str varchar(8000)
exec sp_test @str output
print @str

[子陌红尘]

以上语句拷贝至SQL Server查询分析器中执行。

[xiequanqin]

create function get_result()
returns varchar(4000)
as
begin
declare @sql varchar(4000)
select @sql=''
select @sql=@sql+A+B from Table1
return @sql
end
go


Sql = "Select dbo.get_result()"
Set Rs = Conn.ExeCute(Sql)
If not Rs.Eof Then
s = Rs(0)
End If

[jeall]

谢谢，结贴!