/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 vote202 views4 answers
Open mysql port bitnami tomact
SQL
0 vote313 views1 answer
Postgres list all stored procedures query
SQL
1 vote202 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
32 votes190 views6 answers
Insert select
SQL
6 votes237 views2 answers
Oracle compile trigger
SQL
11 votes197 views3 answers
Python sqlite3 create table if not exists
SQL
1 vote210 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote204 views1 answer
Python connect to mysql in settings.py
SQL
1 vote244 views2 answers
Mysql limit offset
SQL
2 votes342 views1 answer
How to create sql database
SQL