Saturday, December 28, 2013

"select * from table" and "select top 14260 from table" get nothing but select top 14259 get result successful

My sql is "select * from tableName where id='id'", the result is not huge.


About 3 java threads is running this sql to get result.


When the table data is locked, is this bug of Sqlserver or bug of my java program? And h ow can I sove this problem?


Thanks a lot.


No comments:

Post a Comment