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's the maximum size of a row? : Sql server database administration

0 Answers  

---

What is ACID Property of Transaction?

10 Answers  

---

how to find number of columns in a table in sql server 2000 and 2005 also

7 Answers   HCL, Virtusa,

---

How do I view views in sql server?

0 Answers  

---

logshipping is Any difference 2000 and 2005?

2 Answers  

---

Explain table valued parameters in sql server? Why tvp used?

0 Answers  

---

How to include date and time values in sql statements?

0 Answers  

---

could u plz explain about joins and views?

2 Answers  

---

check, not null,unique

2 Answers   IBM,

---

How much is a sql server license?

0 Answers  

---

How to restore performance issues and how to check?

0 Answers  

---

How to delete an existing row with delete statements in ms sql server?

0 Answers  

---