存储过程动态使用表

要12.0版本以上才支持
CREATE PROCEDURE dbo.mytt
(@c varchar(25))
AS
BEGIN
declare @cc varchar(25)
select @cc = "select * from " + @c
exec (@cc)
END