set rd=new adodb.Recordset
set rc=new adodb.Connection
...初始化代码...
rd.cursorlocation=aduseclient
set rd=rc.execute("exec p_GetName")
set rc=new adodb.Connection
...初始化代码...
rd.cursorlocation=aduseclient
set rd=rc.execute("exec p_GetName")
调试欢乐多
set rc=adodb.Connection
...初始化代码...
set rd=rc.execute("exec p_GetName").nextrecordset
试试。
As
set nocount on --****加上这句
Create Table #t0(id int,name nvarchar(16))
Insert #t0(id,name)(Select id,name From TableName Where name like '%mm%')
select id,name from #t0
GO