Answer / madhusudan singh kushwah

Stored procedure return data In 4 ways. which are as follow:

1)output Prameter:-which can return either data(such As
integer or char value) or a cursor variable(cursors are
result sets that can be retreived 1 row at a time).

2)return Codes:-Which are always an Integer Value.

3)A result set for each statement contain in Stored
procedure or any other Stored procedures called by the
Stored Procedure.

4)A global cursor that can refrenced outside the procedure.

Answer / jothi

Cursor

Do you know how to implement service broker?

0 Answers  

---

What is transact-sql ddl trigger?

0 Answers  

---

What is scrollable cursor?

0 Answers  

---

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---

What samples and sample databases are provided by microsoft?

0 Answers  

---

---

how to select 5 to 7 rows from a table, which contains 10 rows?

21 Answers   IBM,

---

WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 Answers  

---

what is the main difference between after trigger and instead trigger.

2 Answers  

---

What are the indexes in sql server?

0 Answers  

---

Can we delete data from a view?

0 Answers  

---

what is the disadvantage of SQL Loder?

1 Answers   TCS,

---

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,

---