sql server 2016 语法

Question

我的sqlserver 是2016版本$dbh = new \PDO("dblib:host=$hostname:$port ;dbname=$dbname", "$username", "$pw");如果是这样$stmt = $dbh->prepare("SELECT top 10 * FROM T_Biz_Goods ");$stmt->execute();while ($row = $stmt->fetch()) {}不会报错，$stmt = $dbh->prepare("SELECT top 10 * FROM T_Biz_Goods where GdsId > 1000 ");$stmt->execute();while ($row = $stmt->fetch()) {}如果是这样，会报错PDO_DBLIB: dbnextrow() returned FAIL我的where这样写应该没错吧，为什么会这样

Answer 1

很简单，你将SELECT top 10 * FROM T_Biz_Goods where GdsId > 1000这条语句，放sql Server数据库自带的（SMSS管理工具）查询分析器运行下 就知道对不对了。能运行成功后再放程序 里执行。