What is Stored procedure ?
- 4 Answers
- 9293 Views
- IBM, iGate, Inspira Technologies, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / arshi
Stored procedure is bunch of query. it more beneficial
then query.
| Is This Answer Correct ? | 1 Yes | 4 No |
What are the three types of anomalies in database and Explain?
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:
Which is the best sorting method if i have to sort the students of Harvard University according to their first name?
After normalization, what are the conditions which have to keep in mind to de-normalize it?
How heap is implemented in database?
What is database collection?
What is odm database?
What is lagging in DBMS ?
what is the full procedure for using store procedure in informatica7.1?
WHAT KIND OF TOOL BO IS?
There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
