Breaking News: Grepper is joining You.com. Read the official announcement!

How should I pass a table name into a stored proc?

omostan answered on May 27, 2020 Popularity 4/10 Helpfulness 1/10

answer How should I pass a table name into a stored proc?

How should I pass a table name into a stored proc?

Comment

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)

Popularity 4/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: sql

Link to this answer
Share Copy Link