改个语句，谢谢

[put2001_ruan]

DECLARE @var VARCHAR(1000)
DECLARE @tables TABLE

SET @var='SELECT [name] INTO '+ @tables + 'FROM titles'
EXEC(@var)
SELECT * FROM @tabels

[klan]

DECLARE @var VARCHAR(1000)

CREATE TABLE #tmp

(
low varchar(20)
)


SET @var='SELECT [name] INTO #tmp FROM titles'
EXEC(@var)
SELECT * FROM #tmp

drop table #tmp

[pengdali]

DECLARE @var VARCHAR(1000)
DECLARE @tables varchar(100)
set @tables='表名'

SET @var='SELECT [name] INTO '+ @tables + 'FROM titles'
EXEC(@var)

exec('SELECT * FROM '+@tabels)

[dafu71]

DECLARE @var VARCHAR(1000)
DECLARE @tables TABLE(name varchar(20))

SET @var='SELECT [name] INTO '+ @tables + 'FROM titles'
EXEC(@var)
SELECT * FROM @tabels

[victorycyz]

@tables没有赋值。'from titles'这里，单引号后要留空格：' from titles'

[dlpseeyou]

DECLARE @var VARCHAR(1000)
DECLARE @tables varchar(10)
set @tables='新表名'

SET @var='SELECT [name] INTO '+ @tables + 'FROM 旧表名'
EXEC (@var)

exec('SELECT * FROM '+@tabels)

[put2001_ruan]

我就是不想用临时表，想用一下table表格数据

[pengdali]

DECLARE @var VARCHAR(1000)
create table #a(name varchar(100))

SET @var='SELECT [name] FROM titles'

insert #a EXEC(@var)


select * from #a