sqlserver模糊查询 分页

用惯了mysql，分页只需要limit。再用这sqlserver分页，还like查询分页，折腾半天。。 $k = '关键字'; $page = 2;//页 $limit = 20;//每页数量 $sql="SELECT TOP $limit $field FROM tableName WHERE ( _id NOT IN (SELECT TOP ".($page-1)*$limit." _id FROM tableName where companyName like '%$k%' ORDER BY _id)) and companyName like '%$k%' ORDER BY _id"; echo $sql; //SELECT TOP 20 * FROM tableName WHERE ( _id NOT IN (SELECT TOP 20 _id FROM tableName where companyName like '%关键字%' ORDER BY _id)) and companyName like '%关键字%' ORDER BY _id