What is Stored procedure ?
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 |
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
Does aggregate and fact tables gets populated from transactional data with only diffrence in there granularity? Please clarify?
What will happen non-clustered index will be created on clustered index?
How do I manually create a database?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
What is sqlcode -923 ?
What are different types of resources?
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?
What is the purpose of TNS?
Data structure used to implements a menu:
What is aws documentdb?
i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name