recordset qa

Results 1 to 2 of 2

Thread: recordset qa

  1. #1
    Join Date
    Dec 1969

    Default recordset qa

    Is it possible to select a specified number of records(exm. 10 records) in a recordset, using stored procedures?

  2. #2
    Join Date
    Dec 1969

    Default SELECT TOP 10 ...

    You can do this even *WITHOUT* stored procedures.<BR><BR>Just use:<BR><BR>SELECT TOP 10 * FROM Table WHERE ... ORDER BY ...<BR><BR>or<BR><BR>SELECT TOP 10 fld1,fld2,fld3 FROM Table WHERE ... ORDER BY ...<BR><BR>NOTE: Not all databases support the TOP 10 syntax in their flavor of SQL. Check your DB&#039s SQL reference manual to be sure it does. (Or try it and see if you get an error.)<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts