/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 vote164 views3 answers
String to int mysql
SQL
0 vote166 views1 answer
Sql developer search all packages for text
SQL
0 vote167 views1 answer
Mysql count with two joins
SQL
4 votes165 views1 answer
Check database name postgresql
SQL
14 votes184 views3 answers
SQL trim
SQL
0 vote167 views1 answer
Show function mysql
SQL
0 vote169 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote156 views1 answer
Oracle free up space in tablespace
SQL
0 vote167 views3 answers
ChAnge TABLE name apex oracle
SQL
-1 vote176 views5 answers
Convert sql to linq query online
SQL