declare @tableName varchar
declare @time varchar
set @tableName='table'
set @time='20130930'
set @sql='select * from '+@tableName+'_'+@time
exec @sql
declare @tableName varchar
declare @time varchar
set @tableName='table'
set @time='20130930'
set @sql='select * from '+@tableName+'_'+@time
exec @sql
转载于:https://www.cnblogs.com/EMTeam/p/3346789.html