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.

Explain a differential backup?

0 Answers  

---

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---

How do indexes help, types?

0 Answers  

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

0 Answers  

---

What is the difference between inner join and equi join?

0 Answers  

---

---

Which TCP/IP port does SQL Server run on?

2 Answers  

---

Diffrent types of function

1 Answers   Wipro,

---

I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.

1 Answers  

---

New concepts of sql server 2005 use in your project.

0 Answers   TCS,

---

how to get the automatic backup of the database in the sql server

4 Answers  

---

How to create hyperlink from returned sql query ?

0 Answers   MCN Solutions,

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   HCL,

---