explain different types of jions with examples briefly?

1 Answers   Zensar,

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---

What do you understand by recursive stored procedures?

0 Answers  

---

Delete duplicate records from the table?(Table must have unique id)

7 Answers   TCS, Thomson Reuters,

---

What is dirty read?

0 Answers  

---

---

What are information schema views?

0 Answers  

---

What does dml stand for?

0 Answers  

---

What is the difference between login and a user?

13 Answers   CTS, TCS,

---

Explain trigger and its types?

0 Answers  

---

Where can you add custom error messages to sql server?

0 Answers  

---

What is normalization and denormalization in sql server?

0 Answers  

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

1 Answers  

---