Question

SQL SERVER如果把变量加入到新建的表名中

DECLARE @YEAR INT
SET @YEAR = 2000
EXECUTE('SELECT * INTO 订单_'+@YEAR+'FROM 订单 WHERE YEAR(订购日期)='+@YEAR)
书中有上面一断代码，意思是，把“订单”表中订购日期为2000年的记录放到新建的表去，这个新表的表名就是 订单+@YEAR ，就是订单2000，但这断代码在SQL SERVER2012中报错，说是订单附近有语法错误，要怎么弄呢？

Answer 1

DECLARE @YEAR INT
SET @YEAR = 2000
EXECUTE('SELECT * INTO 订单_'+@YEAR+' FROM 订单 WHERE YEAR(订购日期)='+@YEAR)
-- FROM 前面加空格隔开

Answer 2

DECLARE @tablename varchar(30)
DECLARE @YEAR varchar(4)

SET @YEAR = '2000'
Set @tablename='订单'+@YEAR

exec( ' Select * into '+@St1+' from 订单 Where YEAR(订购日期)='+''''+@YEAR+'''')