how should i pass a table name into a stored proc 3f

Solutions on MaxInterview for how should i pass a table name into a stored proc 3f by the best coders in the world

Search
showing results for - "how should i pass a table name into a stored proc 3f"
Jessica
10 Mar 2019
1SELECT @ActualTableName = QUOTENAME( TABLE_NAME )
2FROM INFORMATION_SCHEMA.TABLES
3WHERE TABLE_NAME = @PassedTableName
4
5DECLARE @sql AS NVARCHAR(MAX)
6--SELECT @sql = 'SELECT COUNT(*) FROM [' + @ActualTableName + '];'
7
8-- changed to this
9SELECT @sql = 'SELECT COUNT(*) FROM ' + @ActualTableName + ';'
10
11EXEC(@SQL)
source
similar questions
sql stored procedure output parameterdisadvantages of stored procedures sqlbest practive to pass multiple table to stored procedure in sql serverstored procedure with parameters mysqlhow to return a dataset from stored procedure in sql serverset a value by excuting stored procedurems sql server stored procedure output parametersql server stored procedure return value to variablewhat are stored prcedures in sqlcreate stored procedure mysqlcreate procedure sqlsql server execute stored procedure with parametersmysql create stored procedurecreate select stored procedure in sql servercreate table variable in sql stored proceduremysql stored procedure parametersdeclare variable in stored procedure in sql server
queries leading to this page
c 23 how to make table for like the variablepass table name to stored proceduresql server pass table name into stored procedurepass table name as parameter in stored procedure sqlhow to pass table name as parameter in stored procedure in sqldatatable tablename 3d select 28 22formname variable 22 2c new object 5b1 5d 7bname 28 29 7d 29php mysql stored procedure query 2c generate table dynamically by phphow should i pass a table name into a stored proc 3fhow should i pass a table name into a stored proc 3f