Cricket Player Manager
Results 1 to 10 of 10

Thread: SQL procedure to search a database

  1. #1
    International Debutant dinu23's Avatar
    Join Date
    Nov 2004
    Location
    Colombo,Sri Lanka
    Posts
    2,199

    SQL procedure to search a database

    do any of u guys know any websites that I can get an SQL procedure script to seach a MS SQL 2000 database? It's for my Uni project.
    all help appreciated.
    Code:
    CW CRICKET - May 2009
    FC
    M      I     NO    Runs      Avg      Ct      50s      100s      HS
    83    157   8      4237    28.44      79      22         4       169*
    
    O     W    Avg   SR
    45    18   18.7  27
    
    List - A
    M      I      Runs      Avg      Ct    50s    100s      HS
    179   174    5828      37.84     67    48     3        121
    
    OD
    M      I      Runs      Avg    Ct      50s      100s      HS    SR
    27    24     716      35.80    15      6         0       71*   74.58

  2. #2
    International Coach biased indian's Avatar
    Join Date
    Dec 2003
    Location
    office
    Posts
    11,030
    Quote Originally Posted by dinu23
    do any of u guys know any websites that I can get an SQL procedure script to seach a MS SQL 2000 database? It's for my Uni project.
    all help appreciated.
    what kind of search do u want to do???
    Do not argue with an idiot. He will drag you down to his level and beat you with experience.
    RIP Craigos

  3. #3
    Cricket Web: All-Time Legend andyc's Avatar
    Yeti Sports 1.5 Champion!
    Join Date
    Dec 2004
    Location
    Canberra
    Posts
    23,864
    Quote Originally Posted by dinu23
    do any of u guys know any websites that I can get an SQL procedure script to seach a MS SQL 2000 database? It's for my Uni project.
    all help appreciated.
    mate, if i knew what you were talking about, id try to help you
    Quote Originally Posted by flibbertyjibber View Post
    Only a bunch of convicts having been beaten 3-0 and gone 9 tests without a win and won just 1 in 11 against England could go into the home series saying they will win. England will win in Australia again this winter as they are a better side which they have shown this summer. 3-0 doesn't lie girls.

  4. #4
    Hall of Fame Member Sanz's Avatar
    Join Date
    Jan 2004
    Location
    USA
    Posts
    16,230
    Last edited by Sanz; 27-05-2005 at 10:56 AM.


  5. #5
    Cricket Web Owner James's Avatar
    Join Date
    Oct 2001
    Location
    Sydney, Australia
    Posts
    24,147
    Quote Originally Posted by dinu23
    do any of u guys know any websites that I can get an SQL procedure script to seach a MS SQL 2000 database? It's for my Uni project.
    all help appreciated.
    All depends on what you're trying to search for basically and what criteria you need to include.

  6. #6
    International Debutant dinu23's Avatar
    Join Date
    Nov 2004
    Location
    Colombo,Sri Lanka
    Posts
    2,199
    well, it's a database of patients in an ENT ward in a hospital. this is what I want to do:
    when a patient comes the doctor must be able to seach the database to see the details of the patient using the patient ID given to him when the patient first arrived to the ward.

    if the patient can't remember the ID he must produce his name and address to seach the database.

    so the searching must be done using:
    1)patient ID (if the patient has it that is all that is needed to do the search)

    if no patient ID
    use the name and address to do the searching.

  7. #7
    International Debutant dinu23's Avatar
    Join Date
    Nov 2004
    Location
    Colombo,Sri Lanka
    Posts
    2,199
    these sites didn't have what I was looking for, but i've added them to my favourites list just in case something else comes up.

    thanks Sanz.

  8. #8
    Cricket Web Owner James's Avatar
    Join Date
    Oct 2001
    Location
    Sydney, Australia
    Posts
    24,147
    I would say you're after something like:

    Code:
    select * from Patient where PatientID = 'PatientID that user entered'
    
    select * from Patient where Name = 'Name that user entered' and Address ='Address that user entered'

  9. #9
    International Coach biased indian's Avatar
    Join Date
    Dec 2003
    Location
    office
    Posts
    11,030
    select * from Patient where Name Like 'Name that user entered%'

    select * from Patient where Address Like 'Address that user entered%'

    select * from Patient where Name Like 'Name that user entered%' or Address Like 'Address that user entered%'

    this will be of help if u want to search it on your on. thats is if u dont know the exact name or address that u have entred

  10. #10
    International Debutant dinu23's Avatar
    Join Date
    Nov 2004
    Location
    Colombo,Sri Lanka
    Posts
    2,199
    thanks guys. I think I figured it out.



Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 2005 Database Idea Thread
    By Greg Blewett in forum General
    Replies: 91
    Last Post: 23-05-2005, 02:16 AM

Posting Permissions

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