CREATE PROCEDURE [dbo].[chParam]
@Title nvarchar(100) ,
@Result int OUTPUT
AS
DECLARE @strSQL nvarchar(100)
SELECT @strSQL = 'SELECT @Result = Count(*) FROM sw WHERE Title like %'+@Title+'%'
exec(@strSQL)
return @Result
在asp.net里调用这个存储过程后,想取回@Result的数值,怎么取不出来,有什么办法!!!
@Title nvarchar(100) ,
@Result int OUTPUT
AS
DECLARE @strSQL nvarchar(100)
SELECT @strSQL = 'SELECT @Result = Count(*) FROM sw WHERE Title like %'+@Title+'%'
exec(@strSQL)
return @Result
在asp.net里调用这个存储过程后,想取回@Result的数值,怎么取不出来,有什么办法!!!
在sqlParameter里面取
{
oleDbCmd.Parameters[i].ParameterName;//出参名
(string)oleDbCmd.Parameters[i].Value;//值
}
这样都效果!!!
不相信大家试试!!里面用的是exec执行的。返回值取不到
@Title nvarchar(100),
@Result int OUTPUT
AS
declare @RecordCountSql nvarchar(1000)
set @RecordCountSql = N'SELECT @RecordCount = Count(*) FROM sw WHERE Title like %' + @Title + '%'
exec sp_executesql @RecordCountSql, N'@RecordCount int output', @Result output