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

what are the problems in logshipping?

3 Answers  

---

What are the advantages of partitioning?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,

---

What is a view?

6 Answers  

---

---

What is partition, how will you implement it? : sql server analysis services, ssas

0 Answers  

---

How optimize sql query with multiple joins in sql server?

0 Answers  

---

What are diverse clauses that form a part of sql?

0 Answers  

---

Can you get second highest salary from the table?

0 Answers   QuestPond,

---

Explain user defined views?

0 Answers  

---

How to maintain a fill factor in existing indexes?

0 Answers  

---

How do I find my localdb version?

0 Answers  

---