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.

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.

Answer / ravishankar

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

Answer / arshi

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

What is redis good for?

0 Answers  

---

Is database a hardware or software?

0 Answers  

---

Can a database table exist without a primary key?

0 Answers  

---

define primary key index, bitmap index, hash index,virtual indwx

0 Answers   Cap Gemini,

---

Is data lake a database?

0 Answers  

---

hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com

0 Answers   HP,

---

What is ole db source in ssis?

0 Answers  

---

Is hive a database?

0 Answers  

---

aht is the difference b/w network & hierarchial & relational dbms????

0 Answers  

---

1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?

0 Answers  

---

How to implement database security?

0 Answers  

---

How concurrency problems effect the database?

0 Answers   BirlaSoft,

---