Thursday, December 26, 2013

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

I also feel that some part of the row which query is trying to fetch is locked.Although NOLOCK can be solution but it comes with dirty read so unless OP agre. I think we have to look at locking if any.


This is certainly not a bug.




Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


No comments:

Post a Comment