27,579
社区成员
发帖
与我相关
我的任务
分享
--你分页的SQL不对。
SELECT TOP(@pagesize) * FROM users
WHERE userName = @findUserName
AND rowid NOT IN --这儿不应该用userId
(
SELECT TOP(@pagesize*(@pageNow-1)) rowid
FROM users
WHERE userName = @findUserName
)
--呵呵,这个分页的效率不敢恭维
string sql =
"select TOP("+pageSize.ToString()+") * from
(
select * from users
where userName = '"+findUserName+"'
and userId not in
(
select TOP("+ (pageSize*(pageNow-1)).ToString()+") userId
from (select * from users where userName='"+findUserName+"') T
)
)"