| SQL Server 2005中ROW_NUMBER()函数在存储过程分页中的应用 |
| |
| 引用本文： | 郭美娜. SQL Server 2005中ROW_NUMBER()函数在存储过程分页中的应用[J]. 曲靖师范学院学报, 2009, 28(3) |
| |
| 作者姓名： | 郭美娜 |
| |
| 作者单位： | 中国医科大学,计算机中心,辽宁,沈阳,110001 |
| |
| 摘 要： | SQLServer2005中新增的ROW_NUMBER（）函数为存储过程分页提供了便利，提出了多表关联查询时，在一个Select语句中同时使用ROW_NUMBER（）与DISTINCT，DISTINCT失效的解决方法．
|
| 关 键 词： | ROW_NUMBER()函数 |
The Application of SQL Server 2005''''s ROW_NUMBER() Function to Storage Procedure Paging |
| |
| Guo Meina. The Application of SQL Server 2005''''s ROW_NUMBER() Function to Storage Procedure Paging[J]. Journal of Qujing Normal College, 2009, 28(3) |
| |
| Authors: | Guo Meina |
| |
| Affiliation: | Computer Center of Chinese Medical University;Shenyang Liaoning 110001;China |
| |
| Abstract: | 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. |
| |
| Keywords: | SQL Server 2005 DISTINCT |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
