/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

3 votes221 views1 answer
Créer une table sql
SQL
0 vote197 views1 answer
Postgresql get current user name
SQL
0 vote217 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
2 votes213 views1 answer
How to make insert script from table in SQL server
SQL
12 votes218 views4 answers
How to take database dump in postgresql
SQL
2 votes210 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
3 votes481 views1 answer
Postgresql cast
SQL
24 votes236 views5 answers
List mysql users
SQL
0 vote230 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote231 views1 answer
Oracle table privileges
SQL