create PROCEDURE [dbo].[sp_T_NewsPageResults]
(
@startIndex int,
@maximumRows int,
@conditions nvarchar(400)
)
AS
DECLARE @sql nvarchar(4000)
SET @sql='DEClARE @firstID int
SET ROWCOUNT '+CONVERT(nvarchar(10),@startIndex)+'
SELECT @firstID=NewsID FROM
T_News
WHERE '+@conditions+' ORDER BY NewsID DESCSET ROWCOUNT '+CONVERT(nvarchar(10),@maximumRows)+'
SElECT
*FROM
T_News WHERE (NewsID<=@firstID AND '+@conditions+')
ORDER BY NewsID DESCSET ROWCOUNT 0'EXEC sp_executesql @sql
(
@startIndex int,
@maximumRows int,
@conditions nvarchar(400)
)
AS
DECLARE @sql nvarchar(4000)
SET @sql='DEClARE @firstID int
SET ROWCOUNT '+CONVERT(nvarchar(10),@startIndex)+'
SELECT @firstID=NewsID FROM
T_News
WHERE '+@conditions+' ORDER BY NewsID DESCSET ROWCOUNT '+CONVERT(nvarchar(10),@maximumRows)+'
SElECT
*FROM
T_News WHERE (NewsID<=@firstID AND '+@conditions+')
ORDER BY NewsID DESCSET ROWCOUNT 0'EXEC sp_executesql @sql
解决方案 »
- 在页面跳转前想让页面停几秒,应该怎么做
- 怪了!不执行按钮的单击事件!
- 请问怎样用JMail发送附件
- 正则表达式控件如何验证字符串长度不超过5个字?
- C# 中的数组如何绑定到Javascript的数组里,或者在Javacript引用C#的数组.
- DataSet、DataGrid、ViewState的问题
- error msg:"集合已修改;枚举操作可能不会执行。 "
- 关于Request取值的问题,请教!
- 达人们进来看看,怎么实现这个在线时间统计功能。
- C#语句application["test"]=(int32)application["test"]+1;转换为VB.net语句应该如何写法??
- 帮忙解决一下frameset的问题(有源码)
- .net 继承类之间运行的顺序
@maximumRows - 显示记录数
@conditions - 显示记录的条件
create PROCEDURE [dbo].[sp_T_NewsPageResults] (
@startIndex int,
@maximumRows int,
@conditions nvarchar(400)
)ASDECLARE @sql nvarchar(4000)
SET @sql='DEClARE @firstID int
SET ROWCOUNT '+CONVERT(nvarchar(10),@startIndex)+'
SELECT @firstID=NewsID FROM
T_News
WHERE '+@conditions+' ORDER BY NewsID DESCSET ROWCOUNT '+CONVERT(nvarchar(10),@maximumRows)+'
SElECT
*FROM
T_News WHERE (NewsID<=@firstID AND '+@conditions+')
ORDER BY NewsID DESCSET ROWCOUNT 0'EXEC sp_executesql @sql
@startIndex int,
@maximumRows int,
@conditions nvarchar(400)
)ASDECLARE @sql nvarchar(4000)
SET @sql='DEClARE @firstID int
SET ROWCOUNT '+CONVERT(nvarchar(10),@startIndex)+'
SELECT @firstID=NewsID FROM
T_News
WHERE '+@conditions+' ORDER BY NewsID DESCSET ROWCOUNT '+CONVERT(nvarchar(10),@maximumRows)+'
SElECT
*FROM
T_News WHERE (NewsID<=@firstID AND '+@conditions+')
ORDER BY NewsID DESCSET ROWCOUNT 0'EXEC sp_executesql @sql