sqlserver的分页问题

分页用sql语句：

String sql = "SELECT TOP " + pageSize  + " id,name,pwd FROM users WHERE id NOT IN ( SELECT TOP "  + (pageSize * (pageNo - 1))

                  + " id FROM users ORDER BY id )ORDER BY id";

因为top后面不能用？占位符，所以要用字符串拼接。