/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 vote185 views1 answer
The local psql command could not be located
SQL
0 vote232 views1 answer
Duplicate value unique constraint mysql error
SQL
10 votes198 views3 answers
Insert into auto increment mysql
SQL
0 vote188 views1 answer
Sql query to select records entered in last 24 hours
SQL
3 votes245 views1 answer
RENAME table pl sql
SQL
8 votes179 views1 answer
Sql remove characters from string right
SQL
0 vote188 views1 answer
Sqlite closes value
SQL
0 vote207 views1 answer
Alter check command
SQL
8 votes232 views2 answers
How to fetch data from database without last column
SQL
3 votes291 views1 answer
How to get yesterday date in sql
SQL