Answer / ramya gurrala

Cursor is a pointer(in c/java).Cursor work with DML and information can be accessed.

Cursor is required to process each row individually for queries which return multiple rows.

Advantages:1)We can do operations on each row.
2)Response time is good.
3)Cursors are faster than the while loop.

Disadvantages:1)Repeated network round trips.
2)Occupies more resources and temporary storage.

Define left outer join?

0 Answers  

---

How to list all triggers in the database with sys.triggers in ms sql server?

0 Answers  

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

Define ACID properties in a Database?

0 Answers   iNautix,

---

what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,

---

What is a function? Give some example?

3 Answers  

---

Which index created when Create Index on table(col), Why

2 Answers   CGI,

---

Explain different types of lock modes in sql server 2000?

0 Answers  

---

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---

What is an index. What are the types?

0 Answers  

---

What are the differences between UNION and JOINS?

3 Answers   CarrizalSoft Technologies,

---

Explain some DBCC commands?

6 Answers  

---