Technical Article

Paging - Returning a Subset of a Recordset

Use this script to navigate your recordset a page at a time containing a specific number of records and in a specified order.I use the supplier table of the northwind Database to demonstrate thisReturn List of suppliers, ordered by supplier desc, 10 records at a timeexecute prc_lov_SUPPLIERS "", "Suppliers", 1, 1 ''Page oneexecute prc_lov_SUPPLIERS "", […]

You rated this post out of 5. Change rating

2005-09-08 (first published: )

247 reads

Blogs

SQL Server instance metadata inventory with PowerShell and SMO

By

SQL Server instance metadata inventory with PowerShell and SMO The purpose...

5 SQL Tricks Worth Remembering Before You Close the Laptop

By

Disclosure: this post may contain links to books as an affiliate link. If you...

Claude Context Window

By

Every Claude conversation has a context window. It is the total amount of text...

Read the latest Blogs

Forums

Fuzzy String Matching in SQL Server 2025

By Daniel Calbimonte

Comments posted to this topic are about the item Fuzzy String Matching in SQL...

Representing Money

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Representing Money

Celebrating 30 years of PostgreSQL, A Thank you message

By Pat Wright

Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...

Visit the forum

Question of the Day

Representing Money

Which types of currency does the money data type represent?

See possible answers