sql server 2008数据库 查询语句 连表分页 可封装

‘SELECT TOP ‘.$size.’ * FROM ( SELECT row_number() over( ‘.$orderby.’ ) as rownumber ‘.$fieldval.’
FROM ‘.$tb[0].’ LEFT JOIN ‘.$tb[1].’ ON ‘.$oncond.’ ‘.$after_where.’) as numComImg WHERE rownumber>’.($size*($page-1));