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

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

---

How to create a scrollable cursor with the scroll option?

0 Answers  

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

How create table structure only from tableA to TableB if TableA have some data?

4 Answers  

---

What is the query and subquery?

0 Answers  

---

Can we perform backup restore operation on tempdb?

0 Answers  

---

What are the different types of replication you can set up in sql server?

0 Answers  

---

Are connections to sql server encrypted?

0 Answers  

---

Explain system scalar functions?

0 Answers  

---

How efficient you are in oracle and SQL server?

0 Answers   CGI,

---

What are the advantages dts has over bcp?

0 Answers  

---

What is the impact on other user sessions when creating indexes?

0 Answers  

---