SQL SERVER 2005 ROW_NUMBER() OVER() ÅÅÐòÎÞЧ

ÎÒÔÚʹÓÃÒÔÏÂSQLʱ£¬ÅÅÐòÒ»Ö±Õý³£¡£

select
ROW_NUMBER() Over(order by ins_task.last_contact_time asc) as rowNum,
  ins_task.guid taskGuid,
      ins_campaign.task_source as taskSource,
      ins_task.source_guid as sourceGuid,
      ins_task.assigned_to_user taskAssignedToUser,
      ins_task.assigned_by_user taskAssignedByUser,
      CONVERT(varchar(19), ins_task.create_date, 120) taskCreateDate,
      CONVERT(varchar(19), ins_task.last_contact_time, 120) lastContactTime,
ins_task.last_contact_phone      lastContactPhone,
ins_task.last_dict_talker lastDictTalker,
ins_task.last_dict_contact_fail_reason lastDictContactFailReason,
(select name from sys_user where id = ins_task.last_contact_user ) lastContactUser
  from ins_task
  left join ins_campaign on (ins_task.campaign_guid = ins_campaign.guid)
where ins_campaign.project_id = #projectId#

µ«ÔÚ¸ÃSQLÖжà¼ÓÁ˼¸ÁУ¬·¢ÏÖ²»°´over()ÀïÃæµÄlast_contact_timeÅÅÐòÁË¡£

select
ROW_NUMBER() Over(order by ins_task.last_contact_time asc) as rowNum,
  ins_task.guid taskGuid,
      ins_campaign.task_source as taskSource,
      ins_task.source_guid as sourceGuid,
  &