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 is data block and how to define data block size?

0 Answers  

---

Explain what are the database objects? : SQL Server Architecture

0 Answers  

---

What are the difference between primary keys and foreign keys?

0 Answers  

---

How to replace the Query Result 'Null Value' with a text ?

0 Answers   MCN Solutions,

---

How to create a view on an existing table in ms sql server?

0 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,

---

Explain the disadvantages of cursors?

0 Answers  

---

What are the advantages of stored procedure in sql server?

0 Answers  

---

how we can use a database with php.

2 Answers   HCL, IT Solution,

---

How do you size a resultset?

0 Answers  

---

What is difference between stored procedure and user defined function?

0 Answers  

---

Which are the new data types introduced in sql server 2008?

0 Answers  

---