/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

15 votes182 views4 answers
Sql update from select
SQL
1 vote185 views1 answer
Mysql current time
SQL
-1 vote218 views5 answers
Left join sql
SQL
3 votes239 views1 answer
Sql select second max
SQL
0 vote172 views1 answer
Mysql page segment
SQL
0 vote185 views1 answer
Load utilities in sql server
SQL
1 vote186 views2 answers
Oracle difference between two dates in seconds
SQL
-1 vote188 views1 answer
Mysql #1064 error
SQL
1 vote177 views1 answer
Sql select contem uma palavra
SQL
0 vote180 views1 answer
Sql datediff month
SQL