News:

Choose a design and let our professionals help you build a successful website   - ITAcumens

Main Menu

What is called Store Procedure ? ?

Started by thiruvasagamani, Jul 11, 2008, 01:46 PM

Previous topic - Next topic

thiruvasagamani

A stored procedure is a set of SQL commands that has been compiled and stored on the database server.

Once the stored procedure has been "stored", client applications can execute the stored procedure over and over again without sending it to the database server again and without compiling it again.

Stored procedures improve performance by reducing network traffic and CPU load.
Thiruvasakamani Karnan


karthikn

i need one example for stored procedure  :'(

and i have aone more doubt

Can u tell the difference between the Stored Procedure and Function   :educated  :educated ?