Sql server 2005 利用row_number() 函数实现分页

string sql="select * from (" +
                                " select row_number() over(order by b.ID) as row_num,  b.ID,b.英文名,b.中文名,count(a.企业ID) 方案数量 from dbo.企业表 b,dbo.产品方案表 a where  b.ID in (select b.ID from dbo.企业表 b where b.ID in (select distinct d.企业ID from dbo.供应商类别对应表 d,dbo.供应商类别表 c where d.供应商类别ID=c.ID and c.ID=" +
                                serviceID.ToString() + " ) ) and b.ID*=a.企业ID  group by b.ID,b.英文名,b.中文名) as tempTable" +
                                " where row_num between " + recordBegin + " and " + recordEnd ;