What are joins in sql and what are the different types of joins?

0 Answers  

---

How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

Do you know what are the properties of the relational tables?

0 Answers  

---

How to generate create function script on an existing function?

0 Answers  

---

---

What is serializable?

0 Answers  

---

What is the sql server agent?

0 Answers  

---

Explain different isolation levels?

4 Answers  

---

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

---

What is it unwise to create wide clustered index keys?

0 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

What are the 10 characteristics of data quality?

0 Answers  

---