原代码:

EXEC prcRowsCount @tabName='base_user'CREATE PROC prcRowsCountt
@tabName varchar
AS
BEGINDECLARE @strSql varcharSET @strSql='select count(1) from '+@tabNameEXEC (@strSql)
ENDEXEC prcRowsCountt @tabName='base_user'

修改后:

CREATE PROC prcRowsCount
@tabName varchar(255)  
AS
BEGINDECLARE @strSql varchar(255)SET @strSql='select count(1) from '+@tabNameEXEC (@strSql)
ENDEXEC prcRowsCount @tabName='base_user'