/SQL/How should I pass a table name into a stored proc?

How should I pass a table name into a stored proc?

SELECT @ActualTableName = QUOTENAME( TABLE_NAME )
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = @PassedTableName

DECLARE @sql AS NVARCHAR(MAX)
--SELECT @sql = 'SELECT COUNT(*) FROM [' + @ActualTableName + '];'

-- changed to this
SELECT @sql = 'SELECT COUNT(*) FROM ' + @ActualTableName + ';'

EXEC(@SQL)

Source: stackoverflow.com

Similar codes

0 vote300 views1 answer
Sql server for loop
SQL
1 vote287 views1 answer
Postgresql round double precision
SQL
0 vote283 views1 answer
What is top n result in sql
SQL
0 vote285 views1 answer
Postgresql show owner of database
SQL
0 vote323 views1 answer
Mysql concatenate select results
SQL
0 vote272 views1 answer
Drop specific row postgresql
SQL
1 vote272 views1 answer
Import sql file mysql commadn line
SQL
0 vote274 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote265 views1 answer
Psql not found windows
SQL
3 votes286 views1 answer
Postgres kill running query
SQL