C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !






Stored Procedure


Posted Date: 18 Jun 2008    Resource Type: Definitions    Category: General
Author: BuntyMember Level: Diamond    
Rating: Points: 4




A Stored Procedure is a pre-compiled object stored in the database.This means that a procedure is compiled beforehand and is readily available for the various applications to execute.No time is spent on sending the query to the server,parsing,and compiling the procedure again.



Responses
Author: mahendrakiran    31 Oct 2008Member Level: Gold   Points : 2
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.




Author: mahendrakiran    13 Nov 2008Member Level: Gold   Points : 2
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.




Feedbacks      
Popular Tags   What are tags ?   Search Tags  
Stored procedures  .  Stored procedure definiton  .  Stored procedure  .  Definition of a stored procedure  .  

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: Sub-Query
Previous Resource: Extended Stored Procedure
Return to Discussion Resource Index
Post New Resource
Category: General


Post resources and earn money! 		 
Related Resources


dotNet Slackers   BizTalk Adaptors    Web Design

Contact Us    Privacy Policy    Terms Of Use