- 博客(3)
- 收藏
- 关注
RSS订阅原创 ASP高性能分页程序[原创]
SQL="Select ID From News Order By ID Desc"SQLA="Select Title,FilePath,FileName From News where ID In "SQLB=" Order By ID Desc"rs.Open SQL,conn,1,1ThePageCount=1CurrentPage=1ToPage=1If Not rs.Eof Then
2005-10-21 13:38:00
1124
原创 sql 存储过程分页
sql 存储过程分页 CREATE PROC myx_prPageRecordset@queryStr nvarchar(1000), @keyField nvarchar (200), @pageSize int, @pageNumber int ASBEGINDECLARE @sqlText AS nvarchar(4000)DECLARE @sqlTable AS nvarchar(4000
2005-10-09 09:21:00
973
原创 SQL Server 存储过程的分页
建立表： CREATE TABLE [TestTable] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [FirstName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [LastName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [Countr
2005-10-09 09:11:00
1100
2
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人