在sql的MSSM中运行正常,但在帆软中建立数据库查询的预览时报错,请大神帮忙看看如何处理?
语句如下:
if object_id('Tempdb..##TempTable_1') is not null
drop table ##TempTable_1
use XXK
declare @tp1 VARCHAR(50);
declare @zlj1 VARCHAR(400);
declare @zlj2 VARCHAR(400);
set @tp1='d:\images\'
set @zlj1= 'select ImagePath into ##TempTable_1 FROM ..NQImage where DepID=401 and perno='+'''17679'''
exec (@zlj1)
set @zlj2=@tp1+(select * from ##TempTable_1)
select @zlj2 txdz
报错截图如下:
file:///C:\Users\Administrator\AppData\Roaming\Tencent\Users\16544944\QQ\WinTemp\RichOle\W(08O7(VR3]D_X00IB{_]LB.png