What are the different types of locks in the database?

0 Answers  

---

What will be the maximum number of indexes per table?

0 Answers  

---

Define cursor locking

0 Answers  

---

What are the different acid properties?

0 Answers  

---

what is replication? where do u use Go Keyword?

1 Answers   Satyam,

---

---

How to get the definition of a user defined function back?

0 Answers  

---

What is the difference between delete and truncate statements?

0 Answers  

---

define and explain the differences between clustered and non-clustered indexes.

0 Answers   Microsoft,

---

Do you know hot add cpu in sql server 2008?

0 Answers  

---

Explain trigger and its types?

0 Answers  

---

How to create stored procedures with parameters in ms sql server?

0 Answers  

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---