/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

1 vote229 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote248 views3 answers
How to increase size of column in sql
SQL
3 votes244 views2 answers
Sql server current date without time
SQL
0 vote244 views1 answer
Get current date data in mysql
SQL
4 votes227 views2 answers
Oracle default date format
SQL
0 vote258 views1 answer
Python mysql check if database exists
SQL
1 vote230 views1 answer
Mysql show database size in mb
SQL
0 vote223 views1 answer
Mysql query to add hours to column in table
SQL
0 vote232 views1 answer
Mysql DDL
SQL
0 vote256 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL