how to Create of stored procedure

Question

I am working on a desktop application..I want to know how to create a stored procedure,how to call the stored procedure ,how to compile and execute it.
Thanks in advance.