/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 vote102 views1 answer
How to select only a certain date sql
SQL
0 vote104 views1 answer
Sql constarint
SQL
4 votes105 views3 answers
Mysql update with join
SQL
1 vote104 views1 answer
Expression number 1 of select list is not in group by clause
SQL
1 vote102 views2 answers
Sql where keyword
SQL
0 vote108 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote101 views1 answer
Mysql count by month
SQL
0 vote126 views1 answer
Sql server information_schema temp tables
SQL
14 votes101 views3 answers
SQL trim
SQL
8 votes101 views1 answer
Today minus 15 days postgresql
SQL