如何在VC.net中调用带输出参数的存贮过程.sql?
我的存贮过程如下:
CREATE PROCEDURE [dbo].[GetCount]
@RstCount int output,
@TblName nvarchar(100)
as
declare @TmpStr nvarchar(1000)
Set @TmpStr=N'select @RstCount=count(*) from '+ @TblName
exec sp_executesql @TmpStr,N'@RstCount int output',@RstCount output
return @RstCount
GO
在查询窗口调用如下
declare @RecCount int
exec GetCount @RecCount output,'yuanqijian'/*元器件表*/
print @RecCount
成功,而我在VC.Net中调用时总出错,代码如下:
int MyCount=0;
CString SqlStr="exec GetCount MyCount output,'yuanqijian'";
m_SqlDB.ExecuteSQL(SqlStr);//m_SqlDB,为数据库对象,已成功连接上数据源
int a=MyCount;
请问SqlStr该如何写?