试试这个：

Try this:

CREATE PROCEDURE return_table
    @table_name nvarchar(250)
AS
BEGIN
    DECLARE @sql NVARCHAR(MAX)  

    SET @sql = N'SELECT * FROM ' + @table_name
    EXEC(@sql)
END

可以看看你是否使用了查询

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

当我想创建1个函数时多个表的

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