select count(*) from RFM_Portal_Product where spicture is not null
在sql server2005中明明是6913
但是在下面程序返回的结果居然是6900
- Java code
Connection con = GolbalDbInfo1.getConnection(); String sql = "select count(*) from RFM_Portal_Product where spicture is not null"; try { Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(sql); rs.next(); System.out.println(rs.getString(1)); } catch (SQLException e) { e.printStackTrace(); }
------解决方案--------------------
------解决方案--------------------
接分~~