SQL procedure to search a database

dinu23 · 27-05-2005, 08:41 AM

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.

biased indian · 27-05-2005, 09:27 AM

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???

andyc · 27-05-2005, 09:31 AM

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

Sanz · 27-05-2005, 09:32 AM

Try - http://www.sswug.org/ or http://www.sqlservercentral.com/scripts/

James · 27-05-2005, 05:15 PM

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.

dinu23 · 28-05-2005, 04:44 AM

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.

dinu23 · 28-05-2005, 04:57 AM

Quote:

Originally Posted by Sanz

Try - http://www.sswug.org/ or http://www.sqlservercentral.com/scripts/

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.

James · 28-05-2005, 05:02 AM

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'

biased indian · 28-05-2005, 06:14 AM

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

dinu23 · 29-05-2005, 08:06 AM

thanks guys. I think I figured it out.

27-05-2005, 08:41 AM	#1 (permalink)
dinu23 International Debutant 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

27-05-2005, 09:32 AM	#4 (permalink)
Sanz Hall of Fame Member Join Date: Jan 2004 Location: USA Posts: 16,228	Try - http://www.sswug.org/ or http://www.sqlservercentral.com/scripts/ Last edited by Sanz; 27-05-2005 at 09:56 AM.

28-05-2005, 05:02 AM	#8 (permalink)
James Cricket Web Owner Join Date: Oct 2001 Location: Sydney, Australia Posts: 22,297	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'

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
2005 Database Idea Thread	Greg Blewett	General	91	23-05-2005 01:16 AM

28-05-2005, 04:44 AM	#6 (permalink)
dinu23 International Debutant 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.

28-05-2005, 06:14 AM	#9 (permalink)
biased indian International Coach Join Date: Dec 2003 Location: office Posts: 10,972	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

29-05-2005, 08:06 AM	#10 (permalink)
dinu23 International Debutant Join Date: Nov 2004 Location: Colombo,Sri Lanka Posts: 2,199	thanks guys. I think I figured it out.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)