/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 vote301 views2 answers
Get day in sql
SQL
-1 vote315 views2 answers
Postgresql user permissions to database
SQL
0 vote303 views2 answers
Transaction php
SQL
0 vote355 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
7 votes332 views4 answers
Index in mysql
SQL
-1 vote299 views3 answers
Update mongodb version ubuntu
SQL
1 vote330 views2 answers
Mysql extract number from string
SQL
0 vote341 views1 answer
Add super privilege mysql
SQL
9 votes299 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
3 votes337 views2 answers
Update part of a string in mysql
SQL