Answer / manoj pandey

- SELECT is a Query operator, which is also called a set-based approach.

- CURSOR is a looping operator, which is also called a iterative approach or no-set based approach.

Ideally SELECT is more performant than CUSROSR, but there are certain scenarios when CURSOR are the last approach and sometimes beneficial.

More about Cursors:
- Cursor Life Cycle: http://sqlwithmanoj.wordpress.com/2010/10/24/sql-server-cursor-life-cycle/
- Cursor Performance: http://sqlwithmanoj.wordpress.com/2011/02/07/avoid-cursors-or-use-them-optimally/

Check my blog for more Interview Questions: http://sqlwithmanoj.wordpress.com/interview-questions/

What are the requirements to use odbc connections in php scripts?

0 Answers  

---

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,

---

Explain active/passive and active/active cluster configurations?

0 Answers  

---

What is index in an assignment?

0 Answers  

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

0 Answers  

---

Can we add an identity column to decimal datatype?

0 Answers  

---

How to copy data from one table to another table?

0 Answers  

---

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

---

Which joins are sql server default?

0 Answers  

---

How to list all schemas in a database?

0 Answers  

---

Explain system views?

0 Answers  

---

What is the difference between NOROW and LOCKROW?

0 Answers   Accenture, Honeywell, Satyam,

---