向临时表插入记录，查询时提示对象名不存在？

[亚细亚]

 begin
 declare @sqlsg varchar(300)
 declare @deviceName varchar(30)
 set @deviceName='服务器'
 set @sqlsg='select * into  #testsg  from (select * from HardWareRecord_t where deviceName like ''%'+@deviceName+'%'') A '
 exec(@sqlsg)
 select * from #testsg
 end

[三年丿]

把#testsg改成##testsg试试

[亚细亚]

引用 1 楼 qq_25388347 的回复:

数据库上下文的更改只在 EXECUTE 语句结束前有效

begin
declare @sqlsg varchar(300)
declare @deviceName varchar(30)
set @deviceName='服务器'
set @sqlsg='select * into #testsg from (select * from HardWareRecord_t where deviceName like ''%'+@deviceName+'%'') A;select * from #testsg '
exec(@sqlsg)
end

原来如此

引用 1 楼 qq_25388347 的回复:

数据库上下文的更改只在 EXECUTE 语句结束前有效

begin
declare @sqlsg varchar(300)
declare @deviceName varchar(30)
set @deviceName='服务器'
set @sqlsg='select * into #testsg from (select * from HardWareRecord_t where deviceName like ''%'+@deviceName+'%'') A;select * from #testsg '
exec(@sqlsg)
end

如来如此

[亚细亚]

引用 2 楼 三年丿 的回复:

把#testsg改成##testsg试试

恩，改成全局可以

[qq_25388347]

数据库上下文的更改只在 EXECUTE 语句结束前有效 begin declare @sqlsg varchar(300) declare @deviceName varchar(30) set @deviceName='服务器' set @sqlsg='select * into #testsg from (select * from HardWareRecord_t where deviceName like ''%'+@deviceName+'%'') A;select * from #testsg ' exec(@sqlsg) end