/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 vote146 views1 answer
Oracle calculate statistics on partition
SQL
0 vote148 views1 answer
Change redo log file size in mysql 5.6
SQL
0 vote143 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote128 views1 answer
Is numeric in sql
SQL
0 vote141 views1 answer
Mysql date only no time
SQL
2 votes143 views3 answers
Mysql pass command from command line
SQL
0 vote130 views1 answer
Mysql start of today
SQL
0 vote143 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote131 views1 answer
Sql convert datetime to year
SQL
0 vote127 views2 answers
How to get json data mysql
SQL