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 is order of B+tree?

0 Answers   HCL,

---

What is database normalization?

7 Answers   Deloitte, Digicel, JPMorgan Chase, Verifone,

---

How do I view a trc file?

0 Answers  

---

Explain the difference between function and stored procedure?

0 Answers  

---

List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  

---

How do we rollback the table data in SQL Server

3 Answers  

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

---

What is Right Outer Join?

2 Answers  

---

What is onf in normalization form?

0 Answers  

---

What do u mean by orphan users, how will u list them in the DB

2 Answers   IBM,

---

What is schemabinding a view?

0 Answers  

---

What is the difference between varchar and varchar(max) datatypes?

0 Answers  

---