sql 语句问题

[lixin546]

declare @table as nvarchar(50)
set @table = 'table' + (select convert(nvarchar(11),getdate(),112))

select * into @table from table

===============================================
消息 102，级别 15，状态 1，第 4 行
'@table' 附近有语法错误。


请问啥原因啊？？？

[ws_hgo]

[Quote=引用楼主 lixin546 的帖子:]
declare @table as nvarchar(50)
set @table = 'table' + (select convert(nvarchar(11),getdate(),112))

select * into @table from table

===============================================
消息 102，级别 15，状态 1，第 4 行
'@table' 附近有语法错误。


请问啥原因啊？？？
[/Quote]
肯定错啦

[ws_hgo]

select * into @table from table -->这个地方是变量不是表

[ws_hgo]

declare @table as nvarchar(50) 
set @table = 'table' + (select convert(nvarchar(11),getdate(),112)) 

select @table into 你要插入的表  from [table] 

[zzxap]

select * into ['+@table+'] from table

[ljhcy99]

@table 不是表，只是一个变量。
被变量的名字迷惑了

[hwg119]

select * into @table from table 
修改成：
exec('select * into ' + @table  + ' from [table]')