Answer / anindya basu

There are four types of cursor in SQL Server which are:

a. Static
b. Dynamic
c. Forward Only, and
d. Keyset
Static keysets aren't sensitive to database changes and are scrollable.
Dynamic keysets are sensitive to database changes and are scrollable.
Forward only keysets aren't sensitive to database changes and allows only forward scrolling of data. There are 3 variants of Forward Only cursors viz. Forward Only Static, Forward Only Keyset, and Fast Forward. Fast Forward is the fastest of all cursors.
Keyset cursor supports movement from the first row to the last and vice-versa. It doesn't identify inserts but recognizes both updates and deletes.

What is sql server agent and what are the two modes of authentication in sql server?

0 Answers  

---

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,

---

Explain DBMS, RDBMS?

6 Answers  

---

Can we call SP inside a query?

5 Answers   CA, CarrizalSoft Technologies, Wipro,

---

What is difference between standardization and normalization?

0 Answers  

---

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

---

Selet all the data from table where last name is n of employee

2 Answers  

---

What are the properties of the transactions?

0 Answers  

---

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

---

If the job running very slow what is the action you do

0 Answers  

---

How to handle errors in Stored Procedures.

2 Answers   Accenture,

---

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

---