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 are the advantages of using database?
How much does it cost to build a database?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
What is the difference between data source and database?
if i want to display the name of students such that to which city they belong must have count greaer than two
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
How to do performance tunning a database in DB2 V8.2 UDB in linux
What is database and its types?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
Can you create a database in word?
HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?
Can a database table exist without a primary key?
How do you pass parameter in stored procedure?
5. Explain about relational algebra.
What are different types of resources?