/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 vote138 views1 answer
Codigo crear tablas sql server
SQL
0 vote138 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
0 vote121 views1 answer
Android sqlite get rows count
SQL
1 vote149 views1 answer
Oracle activate job
SQL
0 vote123 views1 answer
Azure sql server check foreign key
SQL
0 vote123 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote115 views1 answer
Oracle tablespace autoextend
SQL
0 vote127 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote131 views1 answer
Drop all triggers oracle
SQL
0 vote133 views1 answer
Mysql set boolean default value
SQL