生成存储过程的代码没有使用:
_bstr_t bstrCreate ( L"create proc sp_AdoTest( @OutParam int OUTPUT,@InParam int ) "
L"as "
L"select @OutParam = @InParam + 10 "
L"select * from Table1" <====缺空格
L"return 12345" );
-------------------------
这样就可以了:
1、
set _bstr_t bstrCreate = (if exists (select * from dbo.sysobjects where id = object_id(N'[sp_AdoTest]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [sp_AdoTest]
GO
create proc sp_AdoTest( @OutParam int OUTPUT,@InParam int ) as select @OutParam = @InParam + 10 select * from users return 12345
GO)
感谢各位!
我试了一下,对于没有输出参数和返回值的存储过程,可以使用_RecordsetPtr ,比如下面这个存储过程:
CREATE PROCEDURE findPerson @name varchar(10)
AS
select * from PERSON where 姓名 like @name + '%'
GO