How can delete duplicate records in cte in sql server?

0 Answers  

---

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

---

What is Data model and how to prepare a data model.?

1 Answers   TCS,

---

What are different types of statement?

0 Answers  

---

What is global temp table?

0 Answers  

---

---

Is natural join and equi join same?

0 Answers  

---

Explain an incremental backup?

0 Answers  

---

What is a user-defined function in the sql server and what is its advantage?

0 Answers  

---

What is merge?

0 Answers  

---

What is user-defined function?

0 Answers  

---

Do you know concepts and capabilities of sql server?

0 Answers  

---

What is BLOCK statements in SQL?

0 Answers   HCL,

---