/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 vote303 views2 answers
On delete set default sql server
SQL
0 vote334 views1 answer
Drop domain postgresql
SQL
2 votes370 views2 answers
Null column to 0 in mysql
SQL
16 votes399 views2 answers
Sql vs nosql
SQL
6 votes325 views2 answers
Where clause in sql
SQL
9 votes325 views4 answers
SQL Date Format
SQL
0 vote311 views1 answer
What is mysql_pconnect
SQL
-1 vote319 views1 answer
Add column alter table default value
SQL
0 vote383 views1 answer
Generate a random otp in sql server
SQL
7 votes324 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL