Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Data structure used to implements a menu:

0 Answers   Verifone,


a __________ is a virtual table made up of subset of actual table

2 Answers  


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  


what are wrappers and build ups and what it's use?

0 Answers   TCS,


What is Object Oriented model?

0 Answers   Thomson Reuters,






Is redis in memory database?

0 Answers  


where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

0 Answers  


wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

0 Answers  


What are ACID Properties?

1 Answers   TCS,


Can you tell any two advantages of stored procedures?

0 Answers   Verifone,


A lowest level of security by most RDBMS is

0 Answers   Baan Infotech,


Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

0 Answers   3i Infotech,






Categories