What is Stored procedure ?

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.

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More Databases AllOther Interview Questions

How to do performance tunning a database in DB2 V8.2 UDB in linux

0 Answers  


What is the Lock Based Protocol used for?

0 Answers   Hexaware,


WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

0 Answers   Wipro,


Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it

0 Answers  


Is it good to store images in database?

0 Answers  






Explain data independence & its types.

0 Answers  


What is the difference between oracle and MS Access?

0 Answers   Alcatel-Lucent,


Which three commands cause a transaction to end?

0 Answers   3i Infotech,


What is ase database?

0 Answers  


Explain phantom deadlock?

0 Answers  


What is meant by distributed system?

0 Answers  


can we delete autodiff back up that we have set through sql server agent.

0 Answers   Indian Web Technology,


Categories