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 different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  

---

Name three version of sql server 2000 and also their differences?

1 Answers  

---

What is history table in sql server?

0 Answers  

---

What security features are available for stored procedure?

0 Answers  

---

What is the recovery model? List the types of recovery model available in sql server?

0 Answers  

---

What are data resources?

0 Answers  

---

What is Transparent Data Encryption?

0 Answers  

---

Do you know what are various aggregate functions that are available?

0 Answers  

---

What is the difference between push and pull subscription? : sql server replication

0 Answers  

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

Explain alternate key, candidate key and composite key in sql server?

0 Answers  

---

How to list all user names in a database?

0 Answers  

---