/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 vote288 views1 answer
Psql attribute cannot login
SQL
0 vote311 views1 answer
Mysql sum per week
SQL
6 votes326 views2 answers
Subtr Oracle ?
SQL
0 vote320 views1 answer
Change date format in oracle query
SQL
2 votes273 views1 answer
Select * from table where name like
SQL
0 vote281 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote290 views1 answer
R2dbc-postgresqldriver dependency
SQL
1 vote299 views1 answer
Quit mysql
SQL
10 votes288 views1 answer
Query to find object dependencies in oracle
SQL
0 vote297 views2 answers
Advantages of stored procedures sql
SQL