【will】sql动态拼接表名xxx_000

declare @tableName varchar

declare @time varchar

set @tableName='table'

set @time='20130930'

set @sql='select * from '+@tableName+'_'+@time

exec @sql