CYQ.Data componentsCYQ.Data support multi-database application [Txt,Xml,Access, MSSQL, Oracle,SQLite,MySql], help easily and quickly to develop your project |
CYQ.Data 数据框架 SQL2000 分页存储过程 [第二版]
Principles |
|
|
| #TopicOwner |
本版本的SQL2000分页存储过程相对上一版本,在细节处理上优化了一下,同时将原有仅针对int型的分页,处理兼容了字符串类型。 下面是CYQ.Data 数据框架在SQL2000的第二版本的分页存储过程的代码: PS:如果使用上出现莫名其妙的错误,请将注释删除再看看情况。 set ANSI_NULLS ON Create procedure [dbo].[SelectBase] Declare @Sql nvarchar(2000), @WhereOnly nvarchar(1000),@OrderbyColumn varchar(64) if @Where<>''
exec sp_executeSql @Sql,N'@rowcount int output',@rowcount output if @PageIndex=0 and @PageSize=0 --不进行分页,查询所有数据列表
if CHARINDEX('(', @tableName)>0 --视图SQL语句 if @OrderbyColumn<>'' begin set @Column1=@OrderbyColumn end set @intStart=(@PageIndex-1)*@PageSize+1; set @Sql='Create table #tem(tempID int identity(1,1) not null,Row varchar(64)) '
|
Post Comment
Bulletin
Article Search
Categories
- Platform for dynamic (20)
- Feedback (9)
- Guide (33)
- Principles (19)
- Project-Case (8)
- Business & Buy (2)
- Technology exchange (45)
New Article
- CYQ.Data Components Getting Started Guide [Part 5]-[MProc Execute Stored Procedures or SQL]
- CYQ.Data Components Getting Started Guide [Part 4]-[MAction Insert Delete Update]
- CYQ.Data Components Getting Started Guide [Part 3]-[MAction Get And Set Value]
- CYQ.Data Components Getting Started Guide [Part 2]-[MAction Data Query- Fill And Select]
- CYQ.Data Components Getting Started Guide [Part 1]
New Comment
- When some one searches for his necessary thing, therefore he/she wishes to be available that in detail, so that thing is maintained over here.
- This is my first time pay a quick visit at here and i am in fact happy to read everthing at alone place.
- I truly appreciate this blog article.Really thank you! Cool.
- please pay a visit to the web sites we follow, like this one particular, as it represents our picks in the web
- Really enjoyed this post.Really thank you!
- Really enjoyed this article.Really looking forward to read more. Great.
- poker bonuses What are the norms of copyright of web content? How as it different from Patent?
- Wow! Thank you! I permanently needed to write on my blog something like that. Can I implement a fragment of your post to my site?
- This website was how do I say it? Relevant!! Finally I ave found something that helped me. Cheers!
- I was reading through some of your content on this internet site and I believe this web site is very informative ! Continue posting.