store procedure

[jimmykwh]

any body can tell me what is store procedure. and tell me how to used it..

thank you

[Vit]

Stored procedure is an SQL or set of SQLs stored internally in your database. The advantage of this feature is that stored proc is not recompiled each time you call it and privides mush faster access to your data.
You can use it through your connection object:
conn.execute YourProcedureName