What is Stored procedure ?

Question Posted / gurunadh

4 Answers
10664 Views
IBM, iGate, Inspira Technologies, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is Stored procedure ?..

Answer / nitin bisht

A stored procedure is a group of Transact-SQL statements
compiled into a single execution plan.

Stored procedures return data in four ways:
* Output parameters, which can return either data (such
as an integer or character value) or a cursor variable
(cursors are result sets that can be retrieved one row at a
time).
* Return codes, which are always an integer value.
* A result set for each SELECT statement contained in
the stored procedure or any other stored procedures called
by the stored procedure.
* A global cursor that can be referenced outside the
stored procedure.

Is This Answer Correct ?

3 Yes

0 No

What is Stored procedure ?..

Answer / siva kishore

Def:- Stored Procedure is a set of pre-compiled sql statements.

Advantages:
* No need to compile the sql queries again n again when
using frequently.

* Increases execution performance and also reduces the
burden on the database connection.

Is This Answer Correct ?

3 Yes

0 No

What is Stored procedure ?..

Answer / ravishankar

Stored procedures are pre-compiled object in the Database
which is used to reduce the network traffic.

Is This Answer Correct ?

3 Yes

1 No

What is Stored procedure ?..

Answer / arshi

Stored procedure is bunch of query. it more beneficial
then query.