SQL Server 2005 paging stored procedures and SQL Server 2000 paging stored procedures

 sql Server 2005 paging stored procedures and SQL Server 2000 paging stored procedures, SQL 2005 paging stored procedures in 3 versions, one is not optimized, one is optimized, the last one to support Jion, sql2000 paging stored procedures can also be run on the sql2005, but the performance is not sql2005 version of the good.

use [ svnhost ]

Go

/* * * * objects:  StoredProcedure [dbo].[ up_page2005]    Script Date: 05/21/2008 11:27:05 * * * */

SET ansi_nulls on

go

SET quoted_identifier on

go



CREATE proc [ dbo ] . [ up_page2005 ]

@TableName varchar ( $ ),         -- table name

@Fields

<