Question

在关键字 'from' 附近有语法错误。

数据库操作代码为String sql="select top"+pageSize+"* from Answers where qid="+qid+" and aid not in(select top "+pageSize+"aid from Answers where qid=12)";
错误信息：
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'from' 附近有语法错误。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source)
at Dao.ad.main(ad.java:33)

Answer 1

是不是没有加空格？
导致最后执行了
select top1* from Answers

1> select top1* from #tb;
2> go
消息 156，级别 15，状态 1，服务器 HOME-BED592453C\SQLEXPRESS，第 1 行
关键字 'from' 附近有语法错误。

Answer 2

String sql="select top"+pageSize+" * from Answers where qid="+qid+" and aid not in(select top "+pageSize+" aid from Answers where qid=12)";
试试上面这段。