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
What is database and its types?
What does currency type mean in database?
What is the best database?
what is data access layer?
What is the role of tester in discovery(in Checklist)?
What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?
What is the difference between oracle and MS Access?
Explain the record term used in database.
Differentiate between extension & intension?
i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?
what is tkprof tool and how it is used???
When should you not use firebase?
What are different types of clusters present?
What is aws documentdb?
List the properties of a transaction.