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

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

0 Answers  

---

What is surrogate key? : sql server analysis services, ssas

0 Answers  

---

What is a natural primary key?

0 Answers  

---

What are the restrictions that views have to follow?

0 Answers  

---

Delete duplicate records from the table?(Table must have unique id)

7 Answers   TCS, Thomson Reuters,

---

---

Tell me what is a linked server?

0 Answers  

---

Define cursor locking

0 Answers  

---

What are the 2 types of classifications of constraints in the sql server?

0 Answers  

---

What is self contained multi valued query?

0 Answers  

---

How to fetch the next row from a cursor with a "fetch" statement?

0 Answers  

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

0 Answers  

---

what command is used to create a table by copying the structure of another table?

7 Answers  

---