/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

13 votes132 views2 answers
Get date from now() mysql
SQL
1 vote137 views5 answers
Postgresql difference between two dates in days
SQL
2 votes125 views1 answer
Pandas to sql index
SQL
13 votes154 views3 answers
Sql select from multiple tables without join
SQL
0 vote132 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote132 views1 answer
Mysql xampp reset root password
SQL
0 vote135 views1 answer
Get rows from 1 table with other table empty mysql
SQL
1 vote172 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote127 views1 answer
Top frequency in sql server
SQL
0 vote163 views1 answer
Oracle create package specification
SQL