sql字段排序问题
表结构
BookID   BookName   WeekClicks   MonthClicks   TotolClicks
asp.net的页面中有三个按钮分别是按周排序,按月排序,按总量排序   不需要分页只显示点击的前50条数据   能否用一个存储过程来实现.
我写的代码如下   但是不正确     请高手指点   多谢

alter   PROCEDURE   [dbo].[sp_Book_GetTopBookList]
(
@ListCount   int,     /*显示数量参数*/
@TopType   varchar(50)/*传递排序类别参数*/
)
AS
Begin
SET   ROWCOUNT   @ListCount    
Select   Bookname,BookID,WeekClicks,   MonthClicks     ,TotolClicks   From   Book   Order   by   @TopType   desc
End


------解决方案--------------------
alter PROCEDURE [dbo].[sp_Book_GetTopBookList]
(
@ListCount int, /*显示数量参数*/
@TopType varchar(50)/*传递排序类别参数*/
)
AS
Begin
SET ROWCOUNT @ListCount
exec ( 'Select Bookname,BookID,WeekClicks, MonthClicks ,TotolClicks From Book Order by '+@TopType+ ' desc ')
End

你试试动态SQL行不~~