• We need YOU to help the next generation of students in the community for the new syllabus!
    Share your notes and trial papers on our Notes & Resources page
  • Like us on facebook here

Database design & development -Stored procedures? (1 Viewer)

yeah

Member
Joined
Jan 30, 2004
Messages
103
Gender
Female
HSC
2000
hi everyone,

im just finishing off my database design and development assignment :( and im kinda stuck on one part so im hoping someone can help me!

the assignment case study was about an airline serives for UWS,

i need to: list the identified verbs in the document to help determine any stored procedures. then provide 4 - 5 sample stored procedure specifications and a short description for each. No need to write the actual stored procedure in SQL.

ive lost my textbook unfortunately, and my lecture notes havent gone thru stored procedures so i dont really get it

id really appreciate any help
 

mriethmu

New Member
Joined
Dec 12, 2007
Messages
3
Gender
Male
HSC
2002
yeah said:
hi everyone,

im just finishing off my database design and development assignment :( and im kinda stuck on one part so im hoping someone can help me!

the assignment case study was about an airline serives for UWS,

i need to: list the identified verbs in the document to help determine any stored procedures. then provide 4 - 5 sample stored procedure specifications and a short description for each. No need to write the actual stored procedure in SQL.

ive lost my textbook unfortunately, and my lecture notes havent gone thru stored procedures so i dont really get it

id really appreciate any help
What dont you understand about it? You're not sure what stored procedures are?
There are copious amounts of documentation online that will help you understand it...but basically its just a set of SQL statements that are group together in a function or sub routine.

They're used to query different parts of the database, and to execute different functions, eg Delete a record, selecting a record, updating a record, adding a new record. So when a user logs into a website, the website has to check the database to see if they exist. So it might pass the username and password through to the stored procedure, which would then check to see if the that user existed in the respective user table. It might like this: SELECT * FROM User WHERE Username = @Username AND Password = @Password.

NB: "*" means 'all' - we're selecting all fields, @Username and @Password are the variables we pass through to the stored procedure, and obviously Username and Password are the fields we want to check these variables against.

Hope that helps?
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top