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/

How can you hide the sql server instances?

0 Answers  

---

Different types of keys in SQL?

0 Answers   Infosys,

---

What are different types of views?

0 Answers  

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

0 Answers  

---

How many types of local tables are there in sql server?

0 Answers  

---

Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

---

Can we call future method from trigger?

0 Answers  

---

Can you explain about buffer cash and log cache in sql server?

0 Answers  

---

What is the full form of dql?

0 Answers  

---

when would you go for denormalization? : Sql server database administration

0 Answers  

---

What is Primary key and foreign key? Give an example

4 Answers   TCS,

---