Can see if you use query
CREATE PROCEDURE return_table
(
@table_name_ nvarchar(250)
)
AS
DECLARE @sqlStr nvarchar(max) ,
@ParmDefinition nvarchar(MAX)
Set @sqlStr = 'SELECT * FROM @table_name'
SET @ParmDefinition = N'@table_name nvarchar(250),
EXECUTE sp_executesql @sqlStr,
@ParmDefinition,
@table_name = @table_name_
RETURN
GO
for multiple table when i want create 1 function
CREATE FUNCTION [dbo].[return] ( )
RETURNS TABLE
AS
RETURN
(
select * from
(
SELECT 'EXEC return_table ''tblProduct_01''' AS sp_executesql
UNION ALL
SELECT 'EXEC return_table ''tblProduct_02''' AS sp_executesql
) AS T
)
GO
I is fail