What is Stored procedure ?
- 4 Answers
- 7208 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 |
Data structure used to implements a menu:
a __________ is a virtual table made up of subset of actual table
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
what are wrappers and build ups and what it's use?
What is Object Oriented model?
Is redis in memory database?
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
What are ACID Properties?
Can you tell any two advantages of stored procedures?
A lowest level of security by most RDBMS is
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
-
Oracle (3238) - SQL Server (4518)
- MS Access (429)
- MySQL (1385)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3301)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
