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 statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

What is the difference between local and global temporary tables?

0 Answers  

---

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

0 Answers   QuestPond,

---

What are triggers? How do you invoke a trigger on demand?

0 Answers   Hexaware,

---

Can you name some of the dml commands in sql?

0 Answers  

---

What are the different subsets of sql?

0 Answers  

---

How to verify a login name with sqlcmd tool?

0 Answers  

---

wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......

2 Answers   TCS, Wipro,

---

If we delete pack Spec what will be the status of pack Body ?

0 Answers   Nagarro,

---

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,

---

What is the purpose of object explorer and its features? : sql server management studio

0 Answers  

---

What are different types of join?

0 Answers  

---