/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 vote301 views1 answer
How to input data as id in database sql c#
SQL
0 vote316 views1 answer
How to install postgresql on wsl
SQL
10 votes299 views1 answer
User_dependencies
SQL
1 vote286 views1 answer
Mysql sort by date column
SQL
1 vote305 views1 answer
Sql server select rows by distinct column
SQL
0 vote328 views1 answer
Psql check table fields
SQL
3 votes281 views1 answer
Oracle user quota unlimited
SQL
0 vote318 views2 answers
Unique key
SQL
19 votes304 views6 answers
Sql server drop table if exists
SQL
20 votes290 views4 answers
Reset auto increment in MySQL
SQL