看过此博文后Oracle、MySql、SQLServer 数据分页查询，在根据公司的RegionRes表格做出了
SQLserver的分页查询语句：
SELECT DISTINCT TOP 500
rr.ID AS id
，rr.strName AS name
，rr.nType AS res_type
，rr.nRegID AS region_id
，rr.strChanName AS channel_name
，rr.nChanNum AS channel
，rr.nSortID AS sort_id
，rr.nCamType AS camera_type
，rr
