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

Can we create a clustered index on composite primary key.

3 Answers   IGT,

---

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---

Why is DML provided?

1 Answers   Ernst Young, Thomson Reuters,

---

How to list all columns in a table using odbc_columns()?

0 Answers  

---

What is the order in which the sql query is executed?

0 Answers  

---

could u plz explain about joins and views?

2 Answers  

---

What is the difference between Clustered and Non-Clustered Index?

0 Answers  

---

Explain Geography datatype in SQL Server

0 Answers   Infosys,

---

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

0 Answers   Value Labs,

---

Can multiple columns be used in sql group by clause in ms sql server?

0 Answers  

---

How is foreign key related to primary key?

0 Answers  

---