/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

18 votes179 views6 answers
Creating table in MySQL
SQL
0 vote172 views1 answer
Sql server user permissions and roles
SQL
3 votes176 views1 answer
Oracle user quota on tablespace
SQL
0 vote156 views1 answer
Min mysql
SQL
1 vote170 views1 answer
How to see logical reads in sql server
SQL
0 vote172 views1 answer
Replace multiple string in query sql
SQL
7 votes185 views2 answers
Postgres concat
SQL
12 votes165 views1 answer
Create column sql server
SQL
11 votes173 views2 answers
Import sql file laravel cmd
SQL
0 vote189 views1 answer
Create bdd mysql
SQL