/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 vote133 views1 answer
FindAllBy
SQL
2 votes198 views1 answer
Oracle index size
SQL
0 vote184 views1 answer
Drop constraint in ms sql
SQL
0 vote276 views1 answer
Mariadb hours between two dates
SQL
-1 vote204 views1 answer
Concat two columns in sql server
SQL
0 vote224 views1 answer
Sql server delete records with specific date
SQL
1 vote223 views1 answer
Postgresql create table with timestamp
SQL
0 vote186 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote213 views2 answers
Impala rename column name
SQL
0 vote208 views2 answers
Postgresql gset
SQL