存储过程中使用表名为参数
alter proc AnalysisPhoneModel @phonenum char(11),@mytablename char(100)
as
exec('select * from '+@mytablename+' where phonenum='+@phonenum)
alter proc AnalysisPhoneModel @phonenum char(11),@mytablename char(100)
as
exec('select * from '+@mytablename+' where phonenum='+@phonenum)