在用Ole DB开发前端时的查询时，存储过程中为什么不能够包括更新语句？

[zzhcom]

如:
create proc spTest
@a int
as
update aTable set a = @a
select * from aTable

// 在前端(VC）
[
db_command(L"{ ? = CALL dbo.spTest(?) }")
]
class SpTest
{
public:
[ db_column(1) ] LONG m_a;

[ db_param(1, DBPARAMIO_OUTPUT) ] LONG m_RETURN_VALUE;
[ db_param(2, DBPARAMIO_INPUT) ] LONG m_Param;
};

在另一个程序中调用
SpTest sp;
sp.Open(session);

为什么在Open的时候会报GetInterface() 为空呢，即是sp.m_spRowset = NULL

[zarge]

这样试试

create proc spTest
@a int
as
set nocount on
update aTable set a = @a
select * from aTable
set nocount off

[pengdali]

create proc spTest
@a int
as
set nocount on
update aTable set a = @a
select * from aTable
go

即可！

[zjcxc]

试试,存储过程改为:

create proc spTest
@a int
as
set nocount on
update aTable set a = @a
select * from aTable
set nocount off
go

[sdhdy]

create proc spTest
@a int
as
set nocount on --add
update aTable set a = @a
select * from aTable

[zzhcom]

多谢各位，小弟感激不尽！！