动态SQL查询 [英] dynamin sql query

问题描述

WITH MEM AS
(
    SELECT ROW_NUMBER() OVER ( ORDER BY PRODUCTID) AS ROWNUMBER,PRODUCTNAME FROM PRODUCTS
)

SELECT * FROM MEM ORDER BY ROWNUMBER DESC

我想做一个存储过程.此块是该过程的一部分.谁能告诉我如何使此选择查询动态化?查询我将从asp.net传递.

预先感谢.

I want to make a stored procedure. This block is a part of that procedure. Can any one please tell me how can I make this select query dynamic? Query I will pass from asp.net.

Thanks in advance.

推荐答案

我想您实际上需要知道如何使用动态SQL在SQL Server 2005 中编写用于分页的存储过程(因为您需要使用动态SQL，将需要传递页码，页面大小，订购依据"字段和订购方向(Desc 或Asc)

如果是这样，您可以查看本文 [

I guess you actually need to know how to write a Stored Procedure for Pagination in SQL Server 2005 using Dynamic SQL (Dynamic SQL is required because you would need to pass Page number, Page size, Order By field and Order Direction (Desc or Asc)

If that is so, you can have a look at This Article[^] to learn how to write pagination queries using Dynamic SQL in SQL Server.

您请阅读以下文章: http://www.15seconds.com/issue/070628.htm [ ^ ].它具有一个通用"存储过程，可用于从SQL Server获取任何表的分页数据.

You please take a look at this article : http://www.15seconds.com/issue/070628.htm[^]. This has a "Generic" stored procedure that you can use to get paginated data for any table from SQL Server.

这篇关于动态SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！