What is Store procedure ?

Note that they are called Stored Procedures. There is a little bit of a difference between the words store and stored. A store is typically where people go to buy or get something that someone else put there. Stored can imply that it is something you stored for later use. A Stored Procedure is something that you or someone else that maintains the database has put in the database for later use. The important thing is that Stored Procedures are in the database, not in a program.

Check out this articles may explain very well.
What
How