Results 1 to 1 of 1

Thread: Help with random DB Records

  1. Mar 10th, 2003, 01:39 AM #1
    Brenton
    Brenton is offline

    Thread Starter
    Lively Member Brenton's Avatar
    Join Date
    Jan 2002
    Location
    Look Up!
    Posts
    125

    Question Help with random DB Records

    Hello. I am using a sql server 7 db and want to randomly select a record from the db from a selected table.

    How can I go about do this. I was thinking about getting the record count and then using the random function in VB to get the record, but if this where to be repeated in a loop, I think it would take a bit too long if there are many records in the DB.

    Can anyone help me?
    Last edited by Brenton; Mar 10th, 2003 at 01:45 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width