What is Stored Procedure?

Ads
 

What is Stored Procedure?

What is Stored Procedure?

View Answers

November 18, 2010 at 12:23 PM

Hi,

Here is the answer,

A stored procedure is a named group of SQL statements that have been previously created and stored in the server database. Stored procedures accept input parameters so that a single procedure can be used over the network by several clients using different input data. And when the procedure is modified, all clients automatically get the new version. Stored procedures reduce network traffic and improve performance. Stored procedures can be used to help ensure the integrity of the database.

e.g. sphelpdb, sprenamedb, sp_depends etc.

Syntax is-

CREATE PROCEDURE procedure_name
@param data_type = default_value,
@param data_type = default_value,
@param data_type = default_value
AS

BEGIN
   DELETE FROM  Employees
   WHERE  EmployeeId = @EmployeeId;
END

Ads









Related Tutorials/Questions & Answers:
ModuleNotFoundError: No module named 'django-stored-procedures'
stored procedure
Advertisements
What is procedure
JPA 2.1 Stored Procedure Example
procedures to create struts projects?
stored procedure
ModuleNotFoundError: No module named 'django-event-procedures'
ModuleNotFoundError: No module named 'django-event-procedures'
Fastest way to upload huge raw data in database - c#, Java or stored procedure
ModuleNotFoundError: No module named 'stored'
advantage of stored programs
where this file is stored
Resize image stored in database
Retriving data stored in database
image stored in mysql
update date from stored procedure
Records are not inserting in to main table while running the mysql stored procedure.
ModuleNotFoundError: No module named 'django-stored-queryset'
ModuleNotFoundError: No module named 'django-stored-settings'
ModuleNotFoundError: No module named 'django-stored-queryset'
ModuleNotFoundError: No module named 'django-stored-settings'
ModuleNotFoundError: No module named 'django-stored-filters'
ModuleNotFoundError: No module named 'django-stored-messages'
ModuleNotFoundError: No module named 'django-stored-queryset'
ModuleNotFoundError: No module named 'django-stored-settings'
where are program instructions and data values stored
what is bit
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection

Ads