CREATE PROCEDURE MoreData
@TableName varchar (8),
@iCount varchar(4) OUTPUTAS
DECLARE @SQL VARCHAR(1000)SET @SQL='SELECT id,sTitle FROM '+@TableName
EXEC(@SQL)SET @SQL='SELECT '+@iCount+' =COUNT(*) FROM '+@TableName
EXEC(@SQL)
GO
===================================================================
执行时没有出现异常,第一行查询返回的结果正常,但是第二行的返回参数(总记录数)为空!请帮我改下,谢谢!!!
@TableName varchar (8),
@iCount varchar(4) OUTPUTAS
DECLARE @SQL VARCHAR(1000)SET @SQL='SELECT id,sTitle FROM '+@TableName
EXEC(@SQL)SET @SQL='SELECT '+@iCount+' =COUNT(*) FROM '+@TableName
EXEC(@SQL)
GO
===================================================================
执行时没有出现异常,第一行查询返回的结果正常,但是第二行的返回参数(总记录数)为空!请帮我改下,谢谢!!!
解决方案 »
- Ajax请求url过长怎么办?
- 怎样插入图片呢
- asp.net Atlas、asp.net AjaxPro、asp.net Ajax还有个magicajax
- sqlCommandTimeout报错
- 我的第一个ASP.NET作品----电影网站,大家来看一看
- datetable更新的问题 请教(急)
- 多选删除的问题
- 请问一下有时我不能进行单步调试了,如何设置?谢谢!
- 一个页面两个form提交jquery验证问题
- 关于dropdownlist问题,谢谢,在线等待
- 有关protected void Application_Start(Object sender, EventArgs e)方法?
- 一个存储过程问题
@TableName varchar (8),
@iCount int OUTPUTASDECLARE @SQL VARCHAR(1000)SET @SQL='SELECT id,sTitle FROM '+@TableName
EXEC(@SQL)
Declare @temp int
execute sp_executesql @SQL,N'@temp int out',@temp out
Set @iCount = @tempGO
@TableName varchar (8),
@iCount varchar(4) OUTPUT
AS
DECLARE @SQL VARCHAR(1000)SET @SQL='SELECT id,sTitle FROM '+@TableName
EXEC(@SQL)SET @SQL='SELECT '+@iCount+ '=COUNT(*) FROM '+@TableName
EXEC(@SQL)
GOdeclare @iCount varchar(4)
exec moredata 'authors', @iCount output
print @iCount
cast(@iCount as varchar)
========================================================================
CREATE PROCEDURE MoreData
@TableName varchar (8),
@iCount int OUTPUTAS
DECLARE @SQL NVARCHAR(200)
DECLARE @Temp intSET @SQL='SELECT id,sTitle FROM '+@TableName
EXEC(@SQL)SET @SQL=N'SELECT @Temp =COUNT(id) FROM '+@TableName
EXEC SP_EXECUTESQL @SQL, N' @Temp BIGINT OUTPUT', @Temp OUTPUTSET @iCount = @Temp
GO