4GuysFromRolla.com - A More Efficient Method for Paging Through Large Result S... - The Diigo Meta page

• 26 Apr 13
  

  Jeremy Heier

  "CREATE PROCEDURE [dbo].[usp_PageResults_NAI]
  (
  @startRowIndex int,
  @maximumRows int
  )
  AS
  
  DECLARE @first_id int, @startRow int
  
  -- A check can be added to make sure @startRowIndex isn't > count(1)
  -- from employees before doing any actual work unless it is guaranteed
  -- the caller won't do that
  
  -- Get the first employeeID for our page of records
  SET ROWCOUNT @startRowIndex
  SELECT @first_id = employeeID FROM employees ORDER BY employeeid
  
  -- Now, set the row count to MaximumRows and get
  -- all records >= @first_id
  SET ROWCOUNT @maximumRows
  
  SELECT e.*, d.name as DepartmentName
  FROM employees e
  INNER JOIN Departments D ON
  e.DepartmentID = d.DepartmentID
  WHERE employeeid >= @first_id
  ORDER BY e.EmployeeID
  
  SET ROWCOUNT 0
  
  GO"

  SQL paging sqlserver database

• 13 Dec 11
  

  jiping hu
• 27 Sep 11
  

  Anusidh Pavamontri

  SQL

• 30 Apr 11
  

  Sudip Chakraborty

  SQL

• 31 Jan 10
  

  Victor Onate
• 07 Jan 10
  

  Matt Gumbley

  paging sql sqlserver database

• 21 Dec 09
  

  irahat

  sql_server performance

• 12 Oct 09
  

  Jason Bentley

  sql paging ASP.NET development import

• 27 Sep 09
  

  Who Knows

  database programming development sql

• 16 Sep 09
  

  Joe Jenkins

  The improvements using the the stored procedure are immense when paging data.

  paging sql sqlserver database programming development ASP

• 03 Jun 09
  

  jcassain

  sql paging

• 11 Jun 08
  

  Mike King

  SQLServer StoredProcedures

• 25 Nov 07
  

  Mark Gardner

  paging sql sqlserver asp.net database programming .net

• 19 Nov 07
  

  Jose M Aragon

  A More Efficient Method for Paging Through Large Result Sets

  database sqlserver

• 16 Nov 07
  

  premkumar subbiah thangarajan

  paging SqlServer

• 15 Nov 07
  

  Slobodan Pavkov

  A More Efficient Method for Paging Through Large Result Sets

  asp.net c# sqlserver sqlserver2000 sqlserver2005 paging performance sql db database .net importedfromdelicious

• 14 Nov 07
  

  Ben Ceschi

  delicious

• 07 Nov 07
  

  Chris Armour
  • ----- ----
• 12 Sep 07
  

  janlay

  paging

• 13 Jul 07
  

  Will

  paging gridview

• 15 Mar 07
  

  Daniel Machado

  Método eficiente para paginação em consultas no SQL Server 2000

  paging sql sqlserver2000 database tips development programming sqlserver

• 10 Jan 07
  

  Greg Norman

  ASP.NET sqlserver sql

• 06 Dec 06
  

  alfmor

  pagination paginazione sqlserver fromdelicious

• 30 Oct 06
  

  stereoparty

  paging SQL

• 19 Oct 06
  

  Ryan LaNeve

  paging sqlserver database

• 22 Sep 06
  

  sql

• 16 Sep 06
  

  ricardozanini

  home Desenvolvimento ASP.NET paging sql sqlserver database

• 14 Sep 06
  

  powareverb

  database asp.net paging sqlserver

• 12 May 06
  

  asp.net

• 07 May 06
  

  Jason Reis

  paging sql

• 02 May 06
  

  jschoolcraft

  SQL development Paging

• 

  asp.net sqlserver sql database paging

• 28 Apr 06
  

  jmarsch

  sqlserver

• 26 Apr 06
  

  f. m.

  sql .net asp.net paging tips sqlserver programming stored procedures

• 

  Luciano Evaristo Guerche

  paging sql sqlserver programming tip asp.net datagrid .net dotnet

• 

  Sergio Pereira

  Using ROWCOUNT for a better pagination in SQL2K

  programming tips sqlserver

• 08 Dec 05
  

  rigo2009

  Paging of Recordset directly in SQL-Server

  Dev SQL

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.