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.

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  

---

Do you know what are the differences between lost updates and uncommitted dependencies?

0 Answers  

---

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

---

Explain sp_configure commands, set commands?

3 Answers  

---

How many index keys possible for a table

6 Answers  

---

How to get a list of columns in a view using the "sp_columns" stored procedure?

0 Answers  

---

Explain trigger classes i.e. Instead of and after trigger?

0 Answers  

---

How to use old values to define new values in update statements in ms sql server?

0 Answers  

---

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  

---

What is the difference between NOROW and LOCKROW?

0 Answers   Accenture, Honeywell, Satyam,

---

Magic Tables ?

2 Answers   Thomson Reuters,

---

What is a trace frag? Where do we use it?

0 Answers  

---