/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 vote258 views1 answer
RowDataPacket
SQL
0 vote271 views3 answers
Insert query in ci
SQL
0 vote271 views1 answer
Sql developer connect to sql server
SQL
1 vote274 views1 answer
Cannot drop database because it is currently in use
SQL
1 vote335 views1 answer
Postgresql can you have null foreign key
SQL
51 votes371 views6 answers
Change column name sql
SQL
4 votes264 views1 answer
Oracle select first 10 rows
SQL
2 votes270 views1 answer
Sql as
SQL
2 votes256 views1 answer
Check isolation level in mysql
SQL
1 vote302 views1 answer
Create new table from old table
SQL