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 redis good for?
What is the advantage of varchar2 over char?
Explain artificial key?
What is aws documentdb?
how can we view column head in first page but not in remaining pages?
What is difference between server and database?
how can you perform lookup range in lookup stage expalin in detail?
Explain inner and outer joins with examples.
Explain entity ?
can u combine pipeline parallelism and partition parallalism? how and whan?
What are different types of blocks used in stored procedure?
Explain alternate key?
What is the difference between specialization and generalization?
How to shrink a database?
What is a database example?