How can we solve concurrency problems?

0 Answers  

---

What are the lambda triggers?

0 Answers  

---

Is BCNF better than 2NF & 3NF? Why?

0 Answers   Akamai Technologies,

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

What command do we use to rename a db, a table and a column?

0 Answers  

---

---

Mention the uses of stored procedures.

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,

---

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,

---

Can you roll back the ddl statement in a trigger?

0 Answers  

---

What is the difference between HAVING clause and the WHERE clause?

7 Answers  

---

diffrence between Cluster Index and non Cluster Index

3 Answers   Wipro,

---

What are the advantages dts has over bcp?

0 Answers  

---