What is Stored procedure ?
Answer Posted / 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 |
Post New Answer View All Answers
Write a query to retrieve for many to many relationships?
HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?
Is it good to store images in database?
what is the role of auditor in auditing data oriented applications?
What is the difference between a stored procedure and a query?
What is difference between clustered, non-clustered and unique index?
What is the Lock Based Protocol used for?
Should I store images in database?
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
What is aws documentdb?
Why do we need distributed database?
What is the function of cluster index?
How do you connect to a database?
What are different types of blocks used in stored procedure?
What is the relationship that exists inside in E-R diagram?