SQL SERVER中动态排序数据库查询结果的方法探讨

Dynamic Sorting Methods for the Result of Database Query in SQL Server

在SQLSERVER中把数据库查询结果按某个字段排序输出,这是一个在实际使用中经常碰到的问题,如何把数据库查询结果的静态排序输出转为通过存储过程来实现动态排序,该文就此问题作了探讨。

In SQL Server the result of database query is ordered by fields , which is much used in practice. In this paper we'll discuss some methods for converting the static sort of database query into dynamic sort by stored procedures.