Interested to Buy Any Domain ? << Click Here >> for more details...
What is Stored procedure ?
- 4 Answers
- 10944 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 a sequence? Explain it with one example?
give a simple example of physical and logical data independence
Is database a hardware or software?
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
What is database server and how it works?
Is hive a database?
How many indexes can be created on a table?
What is a Database?
What is the difference between specialization and generalization?
How do database connections work?
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 are different types of joins used in?
List the properties of a transaction.
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 ?
Explain normalization in one line?
