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.

What are the advantages of using database?

975

---

How much does it cost to build a database?

961

---

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)?

1874

---

What is the difference between data source and database?

1008

---

if i want to display the name of students such that to which city they belong must have count greaer than two

2169

---

how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.

1550

---

How to do performance tunning a database in DB2 V8.2 UDB in linux

2218

---

What is database and its types?

949

---

During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?

1328

---

Can you create a database in word?

987

---

HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?

2379

---

Can a database table exist without a primary key?

888

---

How do you pass parameter in stored procedure?

1145

---

5. Explain about relational algebra.

2114

---

What are different types of resources?

953

---