/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 vote406 views2 answers
Mysql limit offset
SQL
0 vote352 views1 answer
Install postgresql 12 on debian 10
SQL
1 vote371 views1 answer
What is int in mysql
SQL
2 votes379 views1 answer
Mysql select default if null
SQL
9 votes354 views3 answers
Oracle undo usage by session
SQL
1 vote349 views1 answer
Sql server locks
SQL
0 vote361 views1 answer
Get foreign table names mysql
SQL
0 vote344 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote353 views1 answer
Update row in sqlite python
SQL
8 votes346 views5 answers
Alter table add column with default value
SQL