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 '
)
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 '
)
set @tableName='aaa'+cast(year(@tdate)as varchar(4))
IF OBJECT_ID(@tableName) IS NULL
EXEC('
SELECT a.*
INTO '+@tableName+' FROM #jxcrb_kc a '
)
set @tableName='aaa'+cast(year(@tdate)as varchar(4))
IF OBJECT_ID(@tableName) IS NULL
EXEC('
SELECT a.*
INTO '+@tableName+'
FROM #jxcrb_kc a '
)
set @tableName='aaa'+cast(year(@tdate)as varchar(4))
IF OBJECT_ID(@tableName) IS NULL
EXEC('
SELECT a.*
INTO '+@tableName+'
FROM #jxcrb_kc a '
)