/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 vote254 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
1 vote235 views1 answer
T-sql disable system versioning
SQL
0 vote208 views1 answer
Show size of all tables postgres
SQL
1 vote211 views2 answers
T sql get foreign key
SQL
1 vote211 views1 answer
Blob datatype in mysql
SQL
0 vote205 views1 answer
Django mysqlclient connection string
SQL
0 vote241 views1 answer
Nodejs sql get one to many relationship as array
SQL
1 vote202 views1 answer
Sql bitwise operators
SQL
0 vote202 views1 answer
Power query datetime to date
SQL
1 vote277 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL