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 do you delete duplicate rows in sql server?

0 Answers  

---

What is the benefit of normalization?

0 Answers  

---

How do I schedule a sql server profiler trace?

0 Answers  

---

What is the difference between writing data to mirrored drives versus raid5 drives

0 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

Can you please explain the difference between function and stored procedure?

0 Answers  

---

What is a result set object returned by mssql_query()?

0 Answers  

---

What do you mean by sql server agent?

0 Answers  

---

Explain Normalization and DE normalization

0 Answers   iNautix,

---

What is the use of floor function in sql server?

0 Answers  

---

Can a trigger be created on a view?

0 Answers  

---

any one can explain Self mapping Delegation Remote Credentials

1 Answers  

---