declare @tableName varchar(16)
set @tableName='aaa'+cast(year(@tdate)as varchar(4))
IF OBJECT_ID(@tableName) IS NULL
EXEC('
SELECT a.*
INTO @tableName --错误:第 3 行: '@tableName' 附近有语法错误。
FROM #jxcrb_kc a '
)
应该怎么搞啊?
...全文
165打赏收藏
大家帮我看看:关于建新表的错误!!!
declare @tableName varchar(16) set @tableName='aaa'+cast(year(@tdate)as varchar(4)) IF OBJECT_ID(@tableName) IS NULL EXEC(' SELECT a.* INTO @tableName --错误:第 3 行: '@tableName' 附近有语法错误。 FROM #jxcrb_kc a ' ) 应该怎么搞啊?