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

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

 Explain what is sql override for a source taLle in a mapping?

0 Answers   Informatica,

---

What is database black box testing?

0 Answers  

---

What is "scheduled jobs" or "scheduled tasks"?

0 Answers  

---

What is the difference between a "where" clause and a "having" clause?

0 Answers  

---

What are scalar functions?

0 Answers  

---

how to trace the traffic hitting a sql server? : Sql server database administration

0 Answers  

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

What is the importance of a recovery model?

0 Answers  

---

What do you mean by a Composite primary key?

0 Answers   Genpact,

---

Mention the differences between having and where clause.

0 Answers  

---

What is the benefit of normalization?

0 Answers  

---