使用JDBC执行SQL查询时出现异常

Question

在NetBeans IDE上使用jdbc执行sql查询时，发生异常。我能够使用Microsoft SQL Server Management Studio Express执行相同的查询，没有任何错误。

下面是该查询：

SELECT tcd.RouterCallKey,adc.AgentSkillTargetID,adc.AgentPeripheralNumber,adc.InstrumentPortNumber,adc.ANI,adc.DateTime,adc.TalkTime 
FROM Termination_Call_Detail tcd 
INNER JOIN 
(
SELECT tcd1.RouterCallKey, AgentSkillTargetID,AgentPeripheralNumber,InstrumentPortNumber,ANI,DateTime,TalkTime 
FROM Termination_Call_Detail AS tcd1 WHERE tcd1.AgentSkillTargetID <>'' 
AND tcd1.TalkTime > 0 AND tcd1.TalkTime <=5 AND RouterCallKey <> 0 AND CallDisposition <>28 
AND tcd1.DateTime >= '2011-02-03 12:00:00 AM' AND tcd1.DateTime <= '2011-02-03 11:59:59 PM' 
) adc 
ON adc.RouterCallKey = tcd.RouterCallKey AND tcd.CallDisposition in (52) 
AND tcd.DateTime >= '2011-02-03 12:00:00 AM' AND tcd.DateTime <= '2011-02-03 11:59:59 PM' 
AND LEN(tcd.ANI) > 4 

这里是个例外：

Incorrect syntax near the keyword 'as'。

Answer 1

这两个查询之间必定存在差异。运行SQL Server Profiler来捕获查询或执行System.out.println以显示您在Java中运行的确切查询。注意像缺少空格这样的东西：

"SELECT * FROM" + 
"WHERE problem = 'No space between from and where'";