Answer / madhu

SQL Server stored procedures can return multiple record
sets. The following is an example:

CREATE PROCEDURE procCustomerGet
@CustomerID VarChar(5)
AS
SELECT * FROM Customers
WHERE CustomerID =
@CustomerID
SELECT * FROM Orders
WHERE CustomerID =
@CustomerID

Answer / sd

Select select_list from my_tabel

Answer / sandeep modapathi

using cursor datatype

declare an output data type
@my_cursor CURSOR VARYING OUTPUT

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---

Explain about service Broker functions?

0 Answers  

---

Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

---

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

What is the difference between composite index and covering index?

0 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

---

How to change the ownership of a schema in ms sql server?

0 Answers  

---

What is a self join in sql server?

0 Answers  

---

How to use “drop” keyword in sql server and give an example?

0 Answers  

---

What is meant by referential integrity?

0 Answers   Blue Star,

---