/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 vote134 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote101 views1 answer
Count char in java
SQL
1 vote149 views4 answers
Mysqldump 1 table only
SQL
0 vote141 views1 answer
Find and replace query in wordpress\
SQL
2 votes202 views2 answers
Set value to null sql
SQL
0 vote195 views1 answer
Postgres dump sql insert
SQL
1 vote147 views1 answer
Decalre temp table sql
SQL
0 vote137 views1 answer
Get current date data in mysql
SQL
0 vote149 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote137 views1 answer
MySql Modify Increment
SQL