34,588
社区成员
发帖
与我相关
我的任务
分享
/*引号这样加应该就不会报错了*/
exec('insert into '+@ods_dbname+'.dbo.DictionaryLibrary select * from '+@linkname+'.'+@yuan_dbname+'.dbo.'+@tbname+'
where LastModifyDateTime
between dateadd(day,-1,'+''''+@start_time+''''+') and '+''''+@start_time+''''+'')
/*然后拼接SQL建议如下写 好些*/
DECLARE @SQL VARCHAR(2000)
SET @SQL = '....'
EXEC(@SQL)