CREATE PROCEDURE [PR_TEST]
@S_TABLE_NAME VARCHAR(30)
@L_ROW INT OUTPUT
AS
SET @SQL_USER='SELECT @L_ROW=COUNT(*) FROM ' + @S_TABLE_NAME
exec(@sql_user)
调用执行如下
decalre @anwser int , @tablename varchar(50)
set @tablename = '你的表名'
execute pr_test @tablename @answer OUTPUT
print @answer
---------------------------------------------------------------------------------------
使用excute sp_excuteSql
CREATE PROCEDURE [PR_TEST]
@S_TABLE_NAME VARCHAR(30)
AS
DECLARE @L_ROW INT
SET @SQL_USER='SELECT @L_ROW=COUNT(*) FROM ' + @S_TABLE_NAME
execute sp_executesql N@SQL_USER, N'@l_row int output' ,@L_ROW output
你这样看看可以吗??