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

What do you understand by a view? What does the with check option clause for a view do?

0 Answers  

---

what is a self join? Explain it with an example? : Sql server database administration

0 Answers  

---

can an order by clause be used in a creation of a view?

0 Answers  

---

Tell about MOM Tool(Microsoft Operator Manager)?

0 Answers  

---

Which TCP/IP port does SQL Server run on?

2 Answers  

---

How to insert a new row into a table with "insert into" statements in ms sql server?

0 Answers  

---

Write an sql query to find the names of employees start with ‘a’?

1 Answers  

---

What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

0 Answers  

---

plz send every query in sql server2000

1 Answers   Infosys,

---

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

---

Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,

---