存储过程出错!!
CREATE PROCEDURE 过程名
@rowscount int output,
as
set @rowscounSQL = 'select @rowscount=count(Used_ID) From Used_Auto '
exec(@rowscounSQL)
出错如下
服务器: 消息 137，级别 15，状态 1，行 1
[Microsoft][ODBC SQL Server Driver][SQL Server]必须声明变量 '@rowscount '。
[解决办法]
CREATE PROCEDURE 过程名
@rowscount int output,
as
set @rowscounSQL = 'select ' +@rowscount + '=count(Used_ID) From Used_Auto '
exec(@rowscounSQL)
應該要這樣
[解决办法]
CREATE PROCEDURE 过程名
@rowscount int output
as
declare @rowscounSQL Nvarchar(2000)
set @rowscounSQL = 'select @rowscount=count(Used_ID) From Used_Auto '
EXEC sp_executesql @rowscounSQL, N '@rowscount int Output ',@rowscount Output
