lacaideniu的专栏

<br /><br />表中主键必须为标识列，[ID] int IDENTITY (1,1)//每次自增一 <br />1.分页方案一：(利用Not In和SELECT TOP分页) <br />语句形式： <br />SELECT TOP 10 * <br />FROM TestTable <br />WHERE (ID NOT IN <br />(SELECT TOP 20 id <br />FROM TestTable <br />ORDER BY id)) <br />ORDER BY ID <br

<br /><br />USE [BBS]<br />GO<br />/****** Object:  StoredProcedure [dbo].[Page]    Script Date: 12/18/2010 13:45:41 ******/<br />SET ANSI_NULLS ON<br />GO<br />SET QUOTED_IDENTIFIER ON<br />GO<br />/*<br />  *@curentpage   当前页<br />  *@pagesize     每页记录数<

<br /><br />USE [BBS]<br />GO<br />/****** Object:  StoredProcedure [dbo].[fenye2]    Script Date: 12/18/2010 13:42:38 ******/<br />SET ANSI_NULLS ON<br />GO<br />SET QUOTED_IDENTIFIER ON<br />GO<br />ALTER proc [dbo].[fenye2]<br />(<br />@currentpage int,

<br /><br />USE [test1]<br />GO<br />/****** Object:  StoredProcedure [dbo].[test300]    Script Date: 12/16/2010 18:08:42 ******/<br />SET ANSI_NULLS ON<br />GO<br />SET QUOTED_IDENTIFIER ON<br />GO<br />ALTER proc [dbo].[test300]<br />(<br />@pagecurrent