/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 vote191 views1 answer
Create table variable in sql stored procedure
SQL
0 vote197 views1 answer
Migration graphql
SQL
5 votes193 views1 answer
Oracle drop index if exists
SQL
0 vote218 views4 answers
Rownum in sql
SQL
0 vote182 views1 answer
How to use query in nosql
SQL
0 vote230 views1 answer
Find duplicate users by email address in mysql
SQL
6 votes206 views2 answers
Clear a table in mysql
SQL
1 vote186 views3 answers
Sql union
SQL
0 vote185 views1 answer
Oracle simple quote
SQL
0 vote199 views1 answer
Mysql sleep connections
SQL