/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

2 votes192 views1 answer
Sql percentage with % rounded down
SQL
2 votes176 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote168 views1 answer
Ffeathers express mysql application users login
SQL
0 vote174 views1 answer
Sql trying to delete database in use
SQL
14 votes175 views2 answers
Oracle limit rows
SQL
0 vote172 views1 answer
Sql replace id with name from another table
SQL
1 vote226 views1 answer
Mysql current running queries
SQL
0 vote126 views1 answer
Mysqli or pdo
SQL
0 vote201 views1 answer
How to check foreign key constraint in sql
SQL
1 vote212 views1 answer
Ora-01109 database not open in oracle 19c
SQL