Just use dynamic SQL. Example:
CREATE PROC spGetAll (
@tableName SYSNAME)
AS
BEGIN
DECLARE @sql nvarchar(max)
IF EXISTS (SELECT name FROM sys.objects WHERE name = @tableName)
SET @sql = 'SELECT * FROM test.'+ QUOTENAME(@tableName)
EXEC(@sql) -- Or EXEC sp_executesql @sql
END
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments