/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

1 vote189 views1 answer
Sql server reseed single table
SQL
0 vote190 views1 answer
Wp_query raw sql
SQL
0 vote195 views2 answers
Tsql row number
SQL
0 vote209 views1 answer
SQL add a totals of differemt rows of the same id
SQL
3 votes208 views2 answers
How to start mysql in terminal
SQL
1 vote198 views1 answer
Altering the column name in MySQL to have a default value
SQL
26 votes197 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote236 views1 answer
Sql character index
SQL
0 vote223 views1 answer
How to change the field size of an existing column
SQL
0 vote187 views3 answers
Sql all columns
SQL