CREATE PROCEDURE [Table_Select]( @TableName sysname)ASexec ('select * from ' + @TableName)GO 重要的是把变量声明为sysname类型