Stored Procedure

Posted Date: 23 Sep 2009	Resource Type: Definitions	Category: General
Author: satya	Member Level: Diamond
Rating:	Points: 5

Stored procedure

A stored procedure is a precompiled executable object that contains one or more SQL statements. Stored procedures can have input and output parameters and can issue an integer return code.

Stored procedures have a number of advantages:

• Execution plan retention and reuse
• Query auto parameterization
• Encapsulation of business rules and policies
• Application modularization
• Sharing of application logic between applications
• Access to database objects that is both secure and uniform
• Consistent, safe data modification
• Network bandwidth conservation
• Support for automatic execution at system start-up

Responses

Author: kaleeswaran 24 Sep 2009

Member Level: Gold Points : 1

Hi,
nice one the advantage of stored procedure.

Regards,
Kaleeswaran
http://4xchange.blogspot.com

Author: satya 25 Sep 2009

Member Level: Diamond Points : 0

Thanks kaleeswaran...

Feedbacks

Popular Tags

What are tags ?

Search Tags

Stored Procedure . 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: Definition of loop
	Previous Resource: Cross Language Interoperability in .NET
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

More Resources