/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 vote56 views1 answer
How to set field to null in sql
SQL
0 vote110 views1 answer
Ffeathers express mysql application users login
SQL
1 vote115 views1 answer
Sql select max value from multiple rows
SQL
0 vote102 views1 answer
Shortcut run sql pgadmin
SQL
5 votes99 views2 answers
Oracle to_timestamp
SQL
0 vote68 views2 answers
Sql update from two different database
SQL
2 votes103 views2 answers
Mysql add hours to time field
SQL
0 vote102 views2 answers
Postgresql get last day of month
SQL
1 vote104 views1 answer
Oracle user last connection date
SQL
3 votes50 views2 answers
Mysql sum with condition
SQL