Shulou(Shulou.com)05/31 Report--

This article is to share with you about how to achieve paging storage in SQL Server, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Create the database data_Test:

Create database data_Test GO use data_Test GO create table tb_TestTable-create tables (id int identity (1) primary key, userName nvarchar (20) not null, userPWD nvarchar (20) not null, userEmail nvarchar (40) null) GO

Insert data:

Set identity_insert tb_TestTable on declare @ count int set@count=1 while @ count maximum ID value and intermediate variable (@ pageIndex int, @ pageSize int) as declare @ count int declare @ timediff datetime declare @ sql nvarchar begin set nocount on; select @ count=0,@ID=0,@timediff=getdate () select @ count=@count+1,@ID=case when @ count@pageSize*@pageIndex and IDRank

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.