摘要
SQL Server 2005中新增的ROW_NUMBER()函数为存储过程分页提供了便利,提出了多表关联查询时,在一个Select语句中同时使用ROW_NUMBER()与DISTINCT,DISTINCT失效的解决方法.
The application of the SQL Server 2005＇ s new ROW_NUMBER（ ） function in the process of storage procedure paging is introduced in this article. When doing the multi - table related query, the DISTINCT is inoperative, if one select statement contains the ROW_NUMBER（） function and the DISTINCT.A method for solving the problem is provided in this article.
出处
《曲靖师范学院学报》
2009年第3期66-68,共3页
Journal of Qujing Normal University
