Recordset Paging SQL Server Stored Procedure

Home :: SQL Server :: Recordset Paging

Here is a SQL server stored procedure that you can use to get a page of records from a recordset.

This strategy saves the extra traffic moving all the records in a large table across your local area network (from your database server to your web server). It reduces the load on your webserver (because SQL server has done all the work). It does everything except make the tea!

Call it from an active server page like this...

<%
    Dim cmd
    Set cmd = Server.CreateObject("ADODB.Command")
    With cmd
        .ActiveConnection = [your previously open connection]
        .CommandText =

The rest of this page is hidden, you must be a member to view it

To become a member and get immediate access to the course please join here Free!

Already Enrolled? please click here to Login