Interested to Buy Any Domain ? << Click Here >> for more details...
What is Stored procedure ?
- 4 Answers
- 10819 Views
- IBM, iGate, Inspira Technologies, I also Faced
- E-Mail Answers
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 the best database software for small businesses?
Give the syntax of exception handling used in DBMS?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
How do you connect to a database?
What is lagging in DBMS ?
What happens when shared and exclusive locks are applied on data item?
What is replicaset?
What is a reference table in database?
what are wrappers and build ups and what it's use?
Explain phantom deadlock?
WHAT IS CARDINALITIES OF JOIN?
Explain normalization in one line?
How many indexes can be created on a table?
What is the difference between specialization and generalization?
Is data lake a database?
