例如以下语句:
SELECT *
FROM OPENQUERY(ERPSVR,
'select *
FROM [2_Test_FP].[DBO].Ordr T0
INNER JOIN [2_Test_FP].[DBO].rdr1 T1 ON T0.DocEntry = T1.DocEntry
INNER JOIN [2_Test_FP].[DBO].OSLP T3 ON T0.SlpCode = T3.SlpCode
where t1.ocrcode='L_GK' and t0.doctype='I' and t0.docdate between '2012-03-01' and '2012-08-01'
') 如何在OPENQUERY嵌套查询表达式,及时将表达式中的单引号改成双引号,也会出现错误提示,应该如何设置呢
SELECT *
FROM OPENQUERY(ERPSVR,
'select *
FROM [2_Test_FP].[DBO].Ordr T0
INNER JOIN [2_Test_FP].[DBO].rdr1 T1 ON T0.DocEntry = T1.DocEntry
INNER JOIN [2_Test_FP].[DBO].OSLP T3 ON T0.SlpCode = T3.SlpCode
where t1.ocrcode='L_GK' and t0.doctype='I' and t0.docdate between '2012-03-01' and '2012-08-01'
') 如何在OPENQUERY嵌套查询表达式,及时将表达式中的单引号改成双引号,也会出现错误提示,应该如何设置呢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货