/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

10 votes130 views1 answer
User_dependencies
SQL
0 vote134 views1 answer
Update and keep original value sql
SQL
0 vote150 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote132 views1 answer
Sql developer search all packages for text
SQL
0 vote159 views1 answer
Sp help text in postgresql
SQL
0 vote133 views1 answer
How to start my sql server on mac
SQL
0 vote137 views1 answer
Sql requete number pair
SQL
1 vote143 views1 answer
Psql import backup file for windows
SQL
2 votes131 views2 answers
Created at and updated at in mysql
SQL
16 votes128 views2 answers
Add column to all tables after first column mysql
SQL